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 Morning Amine Jerbi
Thanks again for your help

Could you give me an example of how I could do it?

I'm still new to Power BI

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

Hi

Is it possible to share a sample of your PBIX?

      • 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