Dax funktcion YTD

[DagdasAlbag]

Hello,

if i have a slicer like in the picture and filter after 11/19/2010, i want it to be shown every three years like in the filter until 11/19/2010, 11/19/2019 and 11/19/2018. that means december 2019 and 2018 must not be visible anymore. i have crossed it out. i would be happy about an answer!

[amitchandak]

@DagdasAlbag , Try like this with a date table

Plot with year and month from date table you will get YTD for all year

YTD Corrected =
var _max = format(today(),"YYYYMM")
return
calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),format('Date'[Date],"YYYYMM")<=_max)

or
YTD Corrected =
var _max = format(today(),"YYYYMM")
return
if(format(max('Date'[Date]),"YYYYMM")<=_max, calculate(Sum('order'[Qty]),DATESYTD('Date'[Date])),blank())

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.