Forum Discussion

simplyfab88's avatar
simplyfab88
New Member
4 years ago
Solved

Cumulative Total based on column from calendar

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:   Month   CycleNum 01.01.2021 ...
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi simplyfab88 ,

     

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi simplyfab88 ,

 

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.