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.

     

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Table:

Then you may create a calculated table and build a one-to-many relationship between two tables as follows.

 

Date Table = CALENDARAUTO()

 

 

You can create a measure as below.

Running Total =
CALCULATE(
         SUM('Table'[Value]),
         DATESYTD('Date Table'[Date])
)

 

Finally, you may use matrix visual to show the reslut:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.