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.
I have three data points:
I created a measure to get the date of the previous month which is working fine, but when I try and get the Open cases it is returning 0 and not the value of all centers. My narrative for the most recent month is:
Which while throwing an error for multiple columns is in fact giving me the right total. When I try a similar narrative for my PrevMonth measure I get 0.
If I replace PrevMonth with 02/01/2023 I get the correct total of 87,193 but need this to be dynamic without having to change that all the time.
What am I doing wrong or should (and how would I) create a calculated table or measure first and use that in the narrative.
Thanks.
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 |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 |