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,
I'm having issues with a "YTD last year" measure.
I have the same measures presented on a chart and table, however as you can see on the picture, the YTD last year values are different, while the YTD (current year) values are correct and the same. The YTD last year values are correct on the chart, not the table. The DAX formula for YTD last year is:
Hi @Joachim2108 ,
Please show some sample data. You could check the blog about How to Get Your Question Answered Quickly.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Jay
Followup: I understand the issue has something to do with how PBI calculates totals, however the solutions to these problems are different depending on the context.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |