Calculation Previous Row

[LeonL]

Hi all,

I am looking for a solution to make a calculation with a value from the previous row in a Table Visualisation in PowerBI.

Example: 

• On the 2nd line it should calculate (60.178 - 59.667) / 28,45
• On the 3rd line (60.779 - 60.178) / 32,53
• and so on.

Even if the Table Visualisation will be filtered and sorted, the previous row needs to be the previous row in relation to the values in the Table .

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/get-value-from-Previous-row/td-p/441336

https://community.powerbi.com/t5/Desktop/How-to-refer-to-the-previous-row/td-p/529060

[MattAllington]

Refering to previous rows in Power BI is particularly tricky, for lots of reasons. I suggest you try to bring the relevant record from the previous row forward into the same row. I created a video some time ago showing how to do this. https://youtu.be/xN2IRXQ2CvI