Shift row

[al2021]

How to shift lines with power query? the values of rows x, y and z are shifted by one column

[Anonymous]

Hi @al2021 ,

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.

[Fowmy]

@al2021 

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/p...