Create Calculated Row using Previous Rows and Cell

[CatMiner]

Hi,

I need your help to create a balance visual that must include calculated row . I have included samples showing the main data table and what the output should look like. 

As shown below I want for december, 2022  to add the value of the previous cell balnce to the last 3 rows above minus the first row, so on and so on.

Thanks for your help!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[CatMiner]

Awesome!

Thank you Ashish!

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[CatMiner]

Hi Ashish,

Here is the link to the file.

https://1drv.ms/u/s!AjWKxqUMTHPpqm6Xxc2X2qI05Kkv?e=h2bbsk