Forum Discussion
Need Help Running Total Based on two columns
Hi I have a WEBI Report which is running correctly. I need to build a PowerBI Dashboard. Mostly I am able to replicate, but I am stuck on Running Total formula. I am not able to figure out how to...
Hi Namjan,
You may need to convert your Order Number into a number and remove the P
Create a calculated column in the data table
Order Number = MID(Order No,2,9)
It would look a little like
Run Total = CALCULATE(SUM(Qty Available) - SUM(Qty to be Delivered), FILTER(ALL(Order Number), Order Number <= MAX(Order Number)))
That is what I am guessing the Run Total would be