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.

     

NMOORE's avatar
NMOORE
Helper II
3 years ago

Although I'm quite confdent with DAX I still use the power BI built in measure for running totals. You can't go wrong. Instead of selecting measure, select 'New Quick measure' a few items down. Go down to Running Total on the list. add the desired columns - manipulate the DAX where required. I often add other variables which only start showing data when it's revelant etc.