how to use what if new parameter and subtract from previous cell

[new808user]

Hi Power BI Community, 

I am a new Power BI user and currently trying to recreate some work I did in excel to Power BI. I have provided a screenshot of excel below this. Cell F2 is where a user is able to input a  whole number. From there, in F3 cell, the equation is =F2+ Quantity, which becomes 149. Then the following cell will use the cell above and subtract from quantity of the same row line.

net change = F2 + Quantity (F3)

net change = F3+ Quantity (F4)

Currently in my Power BI. It looks like the following. I am not sure how to do the same method that I did in excel for power BI. Therefore, I used what-if parameter to create a slicer that allows user to input for Quantity simulation. ( This is more ideal for me since it will be easier to create slicer box and let people input values.) Now the equation in quantity simulation is = input field - quantity. This equation only subtracts input field from each quantity. However, I want to be able to subtract it from the previous cell-like how I did in excel. 

If anyone can help me or point me in the right direction. I will greatly appreciate it! 

Thank you!

S

[MFelix]

Hi @new808user ,

How is your Data setup? In this case you need to use a cummulative sum. Can you please share a sample of your data?

[new808user]

Hi @MFelix, 

Thank you for replying to the thread! I am really new to this forum and I am not sure how to upload sample data. Can you let me know how I upload sample data here? 

Thank you! MFelix!

[MFelix · Accepted solution]

You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.