Forum Discussion
Timeline Slicer + YTD Measure
- 6 years ago
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!
I would skip time intelligence and just do it the way that works: Time Intelligence the Hard Way allows you to specifically control how you do your time calculation.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008