Forum Discussion
running total not working
Hi,
I am new to powerbi. Came across a requirement for which i am stuck.Refered some forums and used the same solution but did not work for me.Not sure what wrong i am doing.Please help
I have added a new column to create running total.
| Expected output |
| $1 |
| $3 |
| $6 |
| $10 |
| $15 |
| $21 |
| $28 |
| $36 |
| $45 |
| $55 |
| $66 |
| $78 |
| $91 |
Thanks in advance
Hi, Anonymous
Try the formula below:
Running Total Column=
CALCULATE (
SUM ( Sheet1[TotalDay] ),
FILTER (Sheet1,Sheet1[WeekName] <= EARLIER(Sheet1[WeekName])
)
)Best regards,
Yuliana Gu
4 Replies
Any chance you can post some sample data like you posted your expected results (not a screen shot because I can't copy the data) and the formula(s) you are using?
Hi, Anonymous
Try the formula below:
Running Total Column=
CALCULATE (
SUM ( Sheet1[TotalDay] ),
FILTER (Sheet1,Sheet1[WeekName] <= EARLIER(Sheet1[WeekName])
)
)Best regards,
Yuliana Gu
