Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Timeline Slicer + YTD Measure

Hello, everybody! I am using the Timeline Slicer in the months and I am having a problem in the current year (2020). I have filtered the display to only show me the months that have values, that's ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Please refer to this file, if this can help. Check the calculation of LYTD, LYD2 vs others

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I suggested a couple of solutions. In case it still does not help.Can you share sample data and sample output.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 !

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,

    Please refer to this file, if this can help. Check the calculation of LYTD, LYD2 vs others