Get Previous Row Value in Power BI

3 Methods for getting the previous Row Value in Power BI and Power Quey:

- Tables Relationship (RELATED function)
- Power Query (M Language formula)
- DAX (LOOKUPVALUE function)

#powerbi #powerquery #dataanalytics #datamodeling #dax

[PhongMike]

Wonderful tips.. thank you very much..

[kayliedoe]

Super easy and helpful. I'm building a Stock in & out report, and was having trouble getting the "Beginning Period" name, because the Prior period's ending is at the same time the current period's beginning. In my case I need to refer to the next row value, but I think your method will work, can't wait to try!

[gersongimenesbeltran]

Thanks! Neither ChatGPT solved my problem.