Forum Discussion
Matrix
Hi Guys, I have below data YYYYMM PYYYYMM Group_Name Group_Number paid 202007 202007 ABC 1 248 202007 202008 ABC 1 823 202007 202009 ABC 1 365 202007 202010 ABC ...
Hi Dhairya,
Here is the measure:-
paid running total in PYYYYMM =
CALCULATE(
SUM('Sheet1'[paid]),
FILTER(
ALLSELECTED('Sheet1'[PYYYYMM]),
ISONORAFTER('Sheet1'[PYYYYMM], MAX('Sheet1'[PYYYYMM]), DESC)
)
)