Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Is there any way to show "last month of previous year"? Currently I just use simple relative filter to show last "full calendar month", but i want to put last year same month together as a comparison.
so in next month (May 2024), the matrix will show April 2023 and April 2024 only.
I tried to make DAX measure to find "Last month of previous year" but I can't drag it into the filter pane.
Thanks in advance.
Solved! Go to Solution.
Hello! You can create a measure for that by doing Your Measure LY = CALCULATE([Your Measure], SAMEDATELASTYEAR ('YourDateTable'[Date])) then put your new measure in your visual next to your other measure.
Proud to be a Super User! | |
Hello! You can create a measure for that by doing Your Measure LY = CALCULATE([Your Measure], SAMEDATELASTYEAR ('YourDateTable'[Date])) then put your new measure in your visual next to your other measure.
Proud to be a Super User! | |
Thanks! Just sorted it. I was using Countx but it doesn't work. Calculate(Count.... , Sameperiodlastyear.... then it works!
Awesome! Happy I could help!
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |