Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running Total in Matrix

Hi All,   i could able to achieve sum of ll the months. Provided the example for "sum" of all the columns and we are showing that in right hand side.   Is it possible to have running total...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try something like this.

    Sales RT = 
IF(
    NOT ISEMPTY( 'Table' ),
    VAR __maxDate = MAX( 'Calendar'[Date] )
    RETURN
    CALCULATE(
        [Sales],
        'Calendar'[Date] <= __maxDate,
        ALL( 'Calendar' )
    )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

If you create a running total over month and add that to matrix it should work ?

Please refer

https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115

https://www.daxpatterns.com/cumulative-total/

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601