Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago
Solved

Running total

Hello,   I have the following simple table.  How do you create a measure for RUNNING TOTAL that is based on date column?  Thanks.   I will have a date slider.  For example, if I sele...
Need Help
  • HaneeshaThan's avatar
    HaneeshaThan
    3 years ago

    Use this formula when calculating running total measure 

    Running Total = Calculate ( SUM('sample'[QTY]), FILTER( ALL('sample'[Date ]),'sample'[Date ] <= MAX('sample'[Date ])))

    See the sample below for a visual with running total column

     

     

    Hope it helps.

     

HaneeshaThan's avatar
HaneeshaThan
Frequent Visitor
3 years ago

Use this formula when calculating running total measure 

Running Total = Calculate ( SUM('sample'[QTY]), FILTER( ALL('sample'[Date ]),'sample'[Date ] <= MAX('sample'[Date ])))

See the sample below for a visual with running total column

 

 

Hope it helps.

 

Oros's avatar
Oros
Post Prodigy
3 years ago

Hi HaneeshaThan ,

 

This works!  Thanks.