Forum Discussion
Running Total for Charges
Super UserConsider using a Quick Measure for that. It has a "Running Total" pattern that is pretty solid.
I think i may have missed explaining a piece. There are multiple transactions for each Unit which means that in the visual above, the Revenue is actually the sum of many records. I dont think i can use SUMX as the Revenue needs to be summed for the period before I can determine what rate to apply (either the $300 or the $500). I also tried adding a quick measure for a running total with no luck.
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
