Forum Discussion
Timeline Slicer + YTD Measure
Anonymous ,
Please refer to this file, if this can help. Check the calculation of LYTD, LYD2 vs others
Hi amitchandak
The problem in this way is that if a particular month was selected (example only February) it does not accumulate the value of January, because it does not have the YTD.
Slicer selects me every month from January to December even if I have a filter that shows me only the months that have values.
And in this particular case they ask me to see all the measurements in YTD and they want to see that slicer.
Thanks!
Anonymous , I suggested a couple of solutions. In case it still does not help.Can you share sample data and sample output.
Hi amitchandak ! Sorry it took me so long to respond.
I'll try to explain the problem better:When I take measurements with YTD and YTD-1 and the year is complete (2018, 2019) I have no problem.
The problem appears in the current year which is still incomplete (2020).
The problem is particularly in the slider of months, if I select "select all", even if it is in the year 2020 (and has a flag that shows me only the months that have values) it selects me from January to December. That's why it gives me incorrect values (because for YTD-1 it accumulates all the values until December).
In case I don't use the DATESYTD for YTD-1 and only use the SAMEPERIODLASTYEAR as you told me, when I select only one month (example March 2020) it doesn't show me the accumulated of the year.Thanks for your help !
Anonymous ,
Please refer to this file, if this can help. Check the calculation of LYTD, LYD2 vs others