hi
i have a power piviot table
customer #, invoice # invoice, amount, etc...
i would like a Dax formula that would give me a running total based on my customer # field
At every change in customer # it recalculates FOR EX.
<tbody>
</tbody>
Any help is greatly appreciated
i have a power piviot table
customer #, invoice # invoice, amount, etc...
i would like a Dax formula that would give me a running total based on my customer # field
At every change in customer # it recalculates FOR EX.
CUSTOMER # | INVOICE # | AMOUNT | RUNNING TOTAL |
A001 | 1 | 200 | 200 |
A001 | 2 | 200 | 400 |
B001 | 3 | 150 | 150 |
B001 | 4 | 200 | 350 |
<tbody>
</tbody>
Any help is greatly appreciated