running total of sales

[Anonymous]

I need DAX solution for rnning total sales for 1  of my report. 

Thanks in advance

[Anonymous]

Thanks @powerbidev123 , It works

[powerbidev123 · Accepted solution]

Hi @Anonymous 

You can use for example that your table name is sales

Running total= CALCULATE(SUM(Sales[amount]),Filter(ALL(Calendar[Date]),Calendar[Date]<=MAX(Calendar[Date])))

Let me know if this works