Shift row

Anonymous 

I believe you need to access the previous or next row(s) in PQ. You need to create an Index column and use it to shift to a different row: Please refer to this article: 
https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/power-query-get-value-from-previous-row/

Hi Anonymous ,

Sorry, not very clear.

You can provide some dummy data and the expected result. 

I look forward to your reply.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.