Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi, @Anonymous
Try the formula below:
Running Total Column=
CALCULATE (
SUM ( Sheet1[TotalDay] ),
FILTER (Sheet1,Sheet1[WeekName] <= EARLIER(Sheet1[WeekName])
)
)
Best regards,
Yuliana Gu
Hi, @Anonymous
Try the formula below:
Running Total Column=
CALCULATE (
SUM ( Sheet1[TotalDay] ),
FILTER (Sheet1,Sheet1[WeekName] <= EARLIER(Sheet1[WeekName])
)
)
Best regards,
Yuliana Gu
thanks Yuliana
Works fine now
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?
Formula Used
Running Total COLUMN = CALCULATE (SUM ( Sheet1[Total Day] ),
Sheet1[Week Name] <= EARLIER ( Sheet1[Week Name].[Date] ))
Data
Week Name | Total Day |
10/4/2015 | $1 |
11/3/2015 | $2 |
12/3/2015 | $3 |
1/2/2016 | $4 |
2/1/2016 | $5 |
3/2/2016 | $6 |
4/1/2016 | $7 |
5/1/2016 | $8 |
5/31/2016 | $9 |
6/30/2016 | $10 |
7/30/2016 | $11 |
8/29/2016 | $12 |
9/28/2016 | $13 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |