• DanOrc

    SSC Enthusiast

    Points: 165

    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 🙁