topic Re: Cumulative Total based on column from calendar in DAX Commands and Tips

Cumulative Total based on column from calendar

simplyfab88 — Wed, 23 Mar 2022 14:56:31 GMT

Hi all,

I'm trying to create a measure just like TOTALYTD but instead of quarters I would like to use 4 months' cycles.

My calendar table looks like:

What I want to achieve:

Thank you in advance for any tips!

Greg_Deckler — Wed, 23 Mar 2022 14:57:13 GMT

V-lianl-msft — Wed, 30 Mar 2022 06:39:00 GMT

Try to create a measure like below:

Cum = CALCULATE(SUM('Table (2)'[Sales]),FILTER(ALLEXCEPT('Table (2)','Table (2)'[CycleNum]),'Table (2)'[Month]<=MAX('Table (2)'[Month])))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.