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.
Hello,
Please, I want to calculate the cumulative turnover but I have the dimenssion date (Year, quarter, month, day) ie I want to display the cumulated by exploring the data through the year then the quarter then by the month then by the day.
Here is a screenshot explaining the past of the year to the quarter by the month by clicking on the axis.
In short, I look for the DAX formula that allows me to calculate the cumulative turnover.
Thank you.
You might use the TOTALMTD function to display the cumulative using your date column as reference. It automatically creates context around the YEAR context. You only need to specify the date column used in your chart in the TOTALMTD sintaxis. Check the function sintaxis here:
https://docs.microsoft.com/en-us/dax/totalmtd-function-dax,
then try to drive through the hierarchy levels to see what happens.
You might check other similar functions as TOTALQTD or TOTALYTD.
Hello,
I tried these two formulas to calculate the cumulative turnover but it did not work. Can you calculate the cumulated?
Here is a screenshot:
Thank you a lot
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |