Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Getting running total on matrix where date is header

Hi everyone,   I would like to ask for another help regarding a running total of values in a matrix. Please see below image.   I tried to use a cummulative calculations and have tried sever...
Need Help
Show and Tell
  • Padycosmos's avatar
    Padycosmos
    3 years ago
    You can try the following wherein I have included partition by department and changed the expression slightly. hope this works:
    **bleep** total = SUMX(WINDOW(0,ABS,0,REL,SUMMARIZE(ALLSELECTED('Table'),'Table'[Date].[Year],'Table'[Date].[Month],'Table'[Date].[MonthNo],'Table'[Department]),ORDERBY('Table'[Date].[Year],ASC,'Table'[Date].[MonthNo],ASC),KEEP,PARTITIONBY('Table'[Department])),CALCULATE(SUM('Table'[MRR])))
Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago
You can try the following wherein I have included partition by department and changed the expression slightly. hope this works:
**bleep** total = SUMX(WINDOW(0,ABS,0,REL,SUMMARIZE(ALLSELECTED('Table'),'Table'[Date].[Year],'Table'[Date].[Month],'Table'[Date].[MonthNo],'Table'[Department]),ORDERBY('Table'[Date].[Year],ASC,'Table'[Date].[MonthNo],ASC),KEEP,PARTITIONBY('Table'[Department])),CALCULATE(SUM('Table'[MRR])))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Padycosmos,

 

Thank you so much for correcting my previous formula.

Upon trying out the formula you gave, though the calculated values is same compare to the formula I have shown. The total result is different.

Upon computing the result, your formula is by far give the correct value!

 

I am so very thankful for your time! You're the man!
I sincerely appreciate your help!

I though, it is already solved earlier, but now, this case is totally solve 🙂