YTD DAX FORMULA WITH SLIZER WITH DIFFERENT YEAR

[hueuro]

HI 

CAN YOU EXPLAIN THE DAX FORMULA FOR YTD RUNNING TOTAL FOR THE BELOW TABLE

When i select sales catagory D should get 15490 ONLY 

Can you help with the dax formula with the data contain previous year

@dax 

[Chakravarthy]

@hueuro , Create a separate date table, Join date column of date table, with your date column of your table.

Please create a measure like this.

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31")) 

[hueuro]

STILL THE SAME COMMING 

it should pick the value april to nov