Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

• Bill Pearson

  SSCommitted

  Points: 1520

  More actions

  January 14, 2015 at 12:00 am

  #313477

  Comments posted to this topic are about the item Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

• DanOrc

  SSC Enthusiast

  Points: 165

  More actions

  February 7, 2015 at 11:02 am

  #1776219

  Hello Bill,

  please could you help me with this one:

  I want to find the NEW customers LAST YEAR, I mean I want to find the

  number of NEW customers that bought in the same period last year.

  I know how to calculate the number of total customers last year:

  CALCULATE(DISTINCTCOUNT([ClientID]),SAMEPERIODLASTYEAR(DimCalendar[PK_Date]),all(DimCalendar))

  also the number of new customers ever:

  CALCULATE(

  COUNTROWS(DimCustormer),

  FILTER(

  DimCustormer,

  CALCULATE(COUNTROWS(SalesFact ))>0 &&

  CALCULATE(

  COUNTROWS(SalesFact ),

  FILTER(

  ALL(DimCalendar),

  DimCalendar[PK_Date]<MIN(DimCalendar[PK_Date])

  )

  )=0

  )

  )

  but I really want to also have the NEW Custormers LAST YEAR

  Thank you so much!

  I'm struggling for a week already

• denisribeiro

  SSC Veteran

  Points: 214

  More actions

  January 9, 2019 at 11:36 am

  #2018441

  The article´s title is wrong.
  Its not Power BI but PowerPivot you are using.

• pietlinden

  SSC Guru

  Points: 63573

  More actions

  January 9, 2019 at 12:13 pm

  #2018446

  DanOrc - Saturday, February 7, 2015 11:02 AM

  Hello Bill, please could you help me with this one: I want to find the NEW customers LAST YEAR, I mean I want to find thenumber of NEW customers that bought in the same period last year. I know how to calculate the number of total customers last year: CALCULATE(DISTINCTCOUNT([ClientID]),SAMEPERIODLASTYEAR(DimCalendar[PK_Date]),all(DimCalendar))also the number of new customers ever: CALCULATE( COUNTROWS(DimCustormer), FILTER( DimCustormer, CALCULATE(COUNTROWS(SalesFact ))>0 && CALCULATE( COUNTROWS(SalesFact ), FILTER( ALL(DimCalendar), DimCalendar[PK_Date]<MIN(DimCalendar[PK_Date]) ) )=0 ))but I really want to also have the NEW Custormers LAST YEARThank you so much!I'm struggling for a week already

  Don't you want to get the FIRSTDATE for each customer's sale (across all years). Then you know when they were new.