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 🙁