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.

     

Oros's avatar
Oros
Post Prodigy
3 years ago

Hi HaneeshaThan ,

 

Thank you very much for your quick reply.  Unfortunately the formula does not work.  I am getting the same Running Total as the QTY.  Any ideas?  Thanks again.

 

 

vaso's avatar
vaso
Frequent Visitor
2 years ago

OrosHi, did you find any solution?