Forum Discussion
calculate the cumulative
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.
2 Replies
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.