Forum Discussion
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...
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
EXEMPLEThank you all for your help
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
Good trick, However watch out the performance of your report, Date Columns consume space, memory and energy.
