running total not working

[Anonymous]

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

[v-yulgu-msft · Accepted 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

[Anonymous]

thanks Yuliana

Works fine now

[Greg_Deckler]

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?

[Anonymous]

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