How to get LYTD count Given YTD expression ?

[admin11]

Hi All

Below expression working fine :-

COUNT_YTD_COY = TOTALYTD(Distinctcount(SALES[Customer Name]),'Date'[Date])

I try to modify the above expression to get LYTD :-

COUNT_LYTD_COY = TOTALLYTD(Distinctcount(SALES[Customer Name]),'Date'[Date])

But it cannot work.

Hope some one can advise me.

Paul Yeo

[Vera_33 · Accepted solution]

Hi @admin11 

try it

COUNT_LYTD_COY = TOTALYTD(Distinctcount(SALES[Customer Name]),DATEADD('Date'[Date], -1, YEAR ), ALL( 'Date' ) )