Cumulative values - actual plus budget values

[jps_HHH]

Hi all,

I've a list of costs. 

The list contains a column with date and other column that refers if the cost is budget or actual.

I would like to create a graph:

 X axis: months

 Y axis: cumulative values 

The graph should be perfect if the cumulative values over the months uses actual values to create the cumulative bars on the past months and for future months the cumulative values should be the sum of actual values plus the budget values.  

[jps_HHH]

Is it possible to attach the powerbi file to this conversation ? 

[jps_HHH]

The powerBi file 

https://file.io/hyjyf3pA3Fy9

[rajendraongole1]

Hi @jps_HHH - Please find the attached file

I hope it helps

[jps_HHH]

thank for the reply.

I tried to use your formula. Howerver, I have a slicer to filter some things and it does not work. I cannot filter anything 

[v-xuxinyi-msft]

Hi @jps_HHH 

Thanks for the reply from rajendraongole1 .

Since the file you uploaded was deleted, I need to confirm with you, what is the purpose of your using slicer?

Best Regards,
Yulia Xu

[jps_HHH]

sorry i didn't understand your question 

[rajendraongole1]

Hi @jps_HHH - You may need to share file links via DropBox, One Drive, Drive or any other tool.