Running SUM (LINE CHART)- Help Please

[drrai66]

Hi Experts,

How I can Create a Running SUM LINE Chart with Week Number on X AXIS and Value on Y AXIS with Following Data. I Need a Formula which I can apply to my Similar Big Data set. 

Thanks in Advance

Deepak

WEEK Number	Value
1	174
2	294
3	118
4	222
5	399
6	126
7	110
8	164
9	69
10	131
11	262
12	149
13	337
14	188
15	315

[Ashish_Mathur]

Hi,

Assuming your financial year end is 31/12, try my solution here.

[drrai66]

Hi Ashish,

Actually, I could not access your Solution. Can you provide the formula. As you can see in the following view, I have the weekly values per week in Line graph, so now I want to accumulate them  the way you showed me in previous reply. so that values get added up and I get an Increasing Trend.  I have got these values by COUNTING and not SUMMING. I have to do COUNTING to get these values per week and then do a Running sum of them.

Thanks for Help again

Deepak

This is what I have

But I need above chart to be like this which I have in Tableau

[Ashish_Mathur · Accepted solution]

Hi @drrai66,

My solution does exactly that.  What problem are you facing when downloading my file?

[sevenhills]

Hi Ashish

For some reasons when we click the link first time it wont work (in chrome) ... Again you click the same link it works ... I tested twice by closing chrome browser and reclicked the link ...

just FYI. Not that your file is problem, the download link wont show up first time and refresh or clicking the same link it shows 🙂

Thanks 

[drrai66]

Hi Ashish,

Got it finally...

Thanks a lot

Deepak

[Ashish_Mathur]

You are welcome.

[sevenhills]

On a (non) related topic, check this link. The November 2017 update has this built-in feature ... https://powerbi.microsoft.com/en-us/desktop/?WT.mc_id=Blog_Desktop_Update 

In the options, enable quick measures & restart power bi. Add new quick measure, running total ... 

Thanks

[drrai66]

Hi Sevenhills,

Thanks  a lot for this..I am still a newbie to Power BI, but you showed me how to do it. I could get it.

Appreciate

Thanks

Deepak

[Anonymous]

What about a measure like (just replace the table name):

Running Sum = VAR WeekNum = MAX('YourTable'[WEEK Number])
RETURN

Calculate(
	SUM('YourTable'[Value]),
	ALL('YourTable'),
	'YourTable'[WEEK Number] <= WeekNum
)

EDIT:  Now just put this on a Line graph with this measure as the value, and week number as the Axis.