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

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

Hi ngomes 

Since you want to compare Quantities by year selected, I think it would be simple to add 3 date       slicers and cards for each selected year using "Edit interaction" feature to stop slicers from interacting with the wrong cards.

This way you leave the liberty for the user to choose what year on each slicer and for the cards to display the quantity of sales in each year selected 

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

I have this slicer for the user to choose the years

I don't know if I explained myself well, but what I want are not the values of the chosen years, these I have already calculated
what intending is to compare the chosen years