Forum Discussion

drrai66's avatar
drrai66
Resolver 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?

drrai66's avatar
drrai66
Resolver I
8 years ago

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

 

 

  • drrai66's avatar
    drrai66
    Resolver I
    8 years ago

    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