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.
Good day,
I used a quick measure to get the running total for monthly income. I could not use the DATEYTD because we are working on a financial year starting in March and also using trimesters instead of quarters so, I needed to create new date tables the Month table is not seen as a date table but as a text column. I also can't use calendarauto(2) because that creates a circle dependency with a calculated table used elsewhere. I managed to use the quick measure to create a running total.
My question now is how do get a total of my running total, all my running totals counted together?
I'm using it in a matirx and that total is just the last months total.
Also i am getting my data from MS Projects PWA through odatafeed
Thanks in advance
See below quick measure
The fiscal year is also not seen as a date but as a whole number. When I try to convert the year numbers to date instead of whole numbers, it shows other dates.
And my running total works I just need the total of the running total.
You can used YTD setting the "Fiscal Year end":
For example:
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 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |