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,
I am creating a report using an excel file. It is straightforward enough. I just need to calcuate MTD, YTD and the variances between both for range of different years.
I have used these calculations before using quick measures and they worked perfectly. However my MTD Calculations are returning YTD if there is no MTD Value. The Total Calculation at the end is correct but the cells are not. In the first column my calculation works but it is a column not a measure so it has limitations.
Total
Has anyone seen this before or know why it is occuring?
This is the calculation for my Column
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |