Here is some material to look at from the forum regarding Cumulative Totals. Please post a sample PBIX file so that we can better assist if you are still having issues.
https://forum.enterprisedna.co/t/mtd-ytd-showing-total-as-to-date-value-december-but-not-as-sum-of-all-mtd-ytd/3068
Hi,
I need little guidance on the below scenario. please can you help
I have registrations for events. need to show cumulative count of registrations for selected year.
the cumulative count should start in descending order of weeks to go column. attached is a sample data.
Sample.xlsx (11.1 KB)
Hi Sam,
I have worked my way through this rather complicated formula and it is quite brilliant but has a bit of a shortcoming.
Firstly, the total is wrong. In this example, it should be 426, not 412.
The second thing is that I need to reference the result of this in other measures, but now since we have removed the month filter from the calculation, I am getting incorrect results.
As a rather crude example, say I need “Chosen Sales Values”
Chosen Sales values = [Reverse Cumulative]
If I pu…
Thanks