YTD expression return Last yr value , Can it use button to switch to display Current year value ?

[admin11]

Hi All

I have a issue , when i my Date expression :-

CALENDAR(Date(2003,01,01),date(2021,12,31))

Today is Jan 18 2022 ,My YTD expression below it will return Last year Total sales amount.

Sales YTD =

var _max = date(year(today())-0,month(today()),day(today()))

return

TOTALYTD(('SALES'[SALES_]),dateadd('DATE'[Date],-0,year),'DATE'[Date]<=_max)

When i change the date expression to :-

DATE =

CALENDAR ( "2003,1,1", TODAY() )

I can view the above YTD expression , it will display 2022 YTD amount.

May i know how it is possible to insert one more button , so that same YTD expression , can display 2021 YTD or 2022 YTD mount ? 

Paul  

[dvl_ctaul · Accepted solution]

Hi Paul,

Couple of things: Have you gone through the process of marking your Date table as a calendar table? (Right click the table name from your Fields pane > Mark as date table > Mark as date Table > select your unique date column)

If so, then you can simplify your expression to just be:

CALCULATE ( 
[SALES],
DATESYTD('DATES'[Date])
)

Then you can add a year slicer to your canvas. Whichever year you select will give you the YTD value for that value for that year. 

Cheers

[admin11]

@dvl_ctaul 

This is the best reply i get in 2022. Thank you very much.  it is what i am looking for.

Paul