Forum Discussion

NaviKher's avatar
NaviKher
New Member
3 years ago

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 ...
Need Help
Dhairya's avatar
Dhairya
Icon for Solution Supplier rankSolution Supplier
3 years ago

Hey NaviKher, Can you please share the measure that you have plotted?

  • NaviKher's avatar
    NaviKher
    New Member
    3 years ago
    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)
        )
    )