Forum Discussion
SUM / SUMX Column
I'm working with a combined table - Current ERP data + Historical data (.xlsx) merged by query. I used the following formula to create a custom column for weight (also to get rid of the "-") My cu...
I did manage to get this done with a measure, problem is that eventually I'm in need of a running total for the weight column.
Something like this:
As far as I know I'm in need of a column to get to that running total, tried it with the (working) measure but couldnt get it done.
Calculating running total in a measure is slightly different to a column.
Please check this post: https://community.powerbi.com/t5/Desktop/Create-Running-Total-On-A-Calculated-Measure/td-p/164202
Paul Zheng