Forum Discussion

MarianoV's avatar
MarianoV
Frequent Visitor
1 year ago

LY values not in sync within different visualizations when using two different date slicers

Hi everyone!  When I select a specific date from the graph,  the value for the previous year only shows the value for the first selected date from the previous year slicer. For context, I have ...
Need Help
Andreas-Harlak's avatar
Andreas-Harlak
Frequent Visitor
1 year ago

Hi MarianoV ,

did you try a different formula with sameperiodlastyear ?

    • Andreas-Harlak's avatar
      Andreas-Harlak
      Frequent Visitor
      1 year ago

      MarianoV I mean that you can calculate the value of die last year (LV or PP) with 

       

      • MarianoV's avatar
        MarianoV
        Frequent Visitor
        1 year ago

        Andreas-Harlak tried this just now, and apparently it returns the same exact day and not the same day for the week. For example, December 20, 2024 Friday - SAMEPERIODLASTYEAR() returns December 20, 2023 which was on a Wednesday. What I need is to return December 22, 2023 which was the same friday last year.