Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

Running SUM (LINE CHART)- Help Please

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 A...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi drrai66,

     

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.