Forum Discussion

ngomes's avatar
ngomes
Icon for Helper II rankHelper II
3 years ago
Solved

DAX selected years

Good afternoon I have a report in which the user selects the years in which he wants to compare quantities sold, he can choose the years he wants, for example, select 2022, 2020, 2014   I have the...
Need Help
  • ngomes's avatar
    ngomes
    3 years ago

    Hello

    after a lot of struggle i found the solution to my problem

    basically I had to create several calendars and use the formula CALCULATE([Year Value],USERELATIONSHIP('Calendar Year 1'[Date],Sales[Date])) for each selected year

    it Works very well
    send the example for knowledge
    EXEMPLE 


    Thank you all for your help

  • ngomes's avatar
    ngomes
    Icon for Helper II rankHelper II
    3 years ago

    good afternoon again

    That wasn't quite what I wanted, how to add the values of the previous year I know how to do it, I don't know how to compare the year 2021 with 2017 and 2017 with 2015, I don't know if I made myself understood, I send the print

     

    the objective is to compare the 1st year selected with the 2nd selected and the 2nd with the 3rd

     

    Thank you for your help