Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 6 years agoThis 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
AllisonKennedy
Community Champion
6 years agoThis 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
You will need an Index column and you will also need to add a condition that MemberID = prev MemberID