• pietlinden

    SSC Guru

    Points: 62343

    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.