Create an accumulated value

[HersonD]

Hi,

I want to show an accumulative value in my Line and Stacked column chart. 

X axis - Dates

Y-Axis - Values

Line - Accumulated for each day

Also, can I make it dynamic? I tried making an accumulated column in excel but when i used it in power BI it does not change values when I'm using slicers.

[bhanu_gautam · Accepted solution]

@HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters 

https://www.youtube.com/watch?v=ejY64shaa-Y

[Anonymous · Accepted solution]

Thank you bhanu_gautam

Hi, @HersonD 

Based on your description, I created the following dataset:

First, create the following two measures:

Values per day = SUM('Table'[Values]) 

Accumulate per day = 
VAR _date = SELECTEDVALUE('Table'[date])
RETURN 
SUMX(FILTER(ALLSELECTED('Table'[date]),'Table'[date]<=_date),[Values per day])

Create the following two charts and slicers:

Modify the slicer time range and find that you get the correct cumulative for each day:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhanu_gautam · Accepted solution]

@HersonD , Create that column in Power BI and if you want it to be dynamic use what if parameters 

https://www.youtube.com/watch?v=ejY64shaa-Y