Forum Discussion
Running Total with Two Columns
Hello!
I am having trouble writing the DAX for a running total of ordered units. I need to see them by date but also by customer. I have the DAX working for by date:
Required RT = CALCULATE(SUM(FACT_Backorders[Order Quantity]),FILTER(ALL(FACT_Backorders[Delivery Date]), FACT_Backorders[Delivery Date] <=MAX(FACT_Backorders[Delivery Date])))
But when drilling down to customer I lose the running total:
Any advice on how to include customer so I will see a running total overall for the material? Thanks in advance!
1 Reply
kirabray , Try to use the window function with partition by
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
