Forum Discussion
Running Total with a condition
Hi,
I'd like to get some help here!
i want to have a running total value with a tricky condition.
Here is my Table and i normally use a qucick measure but now i need a running total of plan for till 09/09/2019.
the dates are the start dates of a week.. want to see running tatol of plan week by week ..
| DATE | PLAN |
| 02/09/2019 | 15 |
| 02/09/2019 | 1 |
| 02/09/2019 | 2 |
| 02/09/2019 | 3 |
| 09/09/2019 | 4 |
| 09/09/2019 | 5 |
| 09/09/2019 | 3 |
| 16/09/2019 | 6 |
| 16/09/2019 | 2 |
please have a look. any advice would be much appreciated.
can anybody tell me how i can attach the table (excel) here?
thanks,
4 Replies
Anonymous
Take a look at this post, it may help you.
https://community.powerbi.com/t5/Desktop/How-to-calculate-running-totals-starting-from-a-specific-date-to/td-p/283034And please upload your sample to OneDrive for Business, and copy paste the file link here.
Best,
PaulHi,
Show us the exact result which you are expecting.
