Forum Discussion
Power Query - Nested Previous Row
Hello, I am trying to get the Previous Order date in the next column for each client in Power Query (not DAX). I read one tutorial and they suggested using this syntax, but it is not for nes...
- This is the post I used to first reference previous row in Power Query: https://www.myonlinetraininghub.com/referencing-next-row-power-query
You will need an Index column and you will also need to add a condition that MemberID = prev MemberID
Jpss
Resolver II
Resolver III was looking for a similar solution but for extracting next row and with several references, managed to create a solution.
I have documented it in my post here:
https://medium.com/microsoft-power-bi/get-next-row-values-in-a-nested-table-c90622f53d4d?sk=a81b77b345797b9491052dc36a50d8e2
Sharing here incase someone finds it helpful