Query Help to Do the information go up one row

[EduFusiger]

 Hi, Im new here, ... im trying to learn M language. How can i do to do the information of the second column go up one row like the photo.

[v-yulgu-msft · Accepted solution]

Hi @EduFusiger,

Please try the solutions in below links to refer to previous/next row in Power Query.

How to refer to the next row in Power Query

Power Query previous row value based on criteria!! 😮

Best regards,

Yuliana Gu

[Anonymous]

@EduFusiger,

You can use Fill Up under Transform Tab on the second column in Query Editor

[EduFusiger]

Thanks, but this makes the information goes up to all the Rows .... I need the information of the second column goes up just 1 rows

[v-yulgu-msft · Accepted solution]

Hi @EduFusiger,

Please try the solutions in below links to refer to previous/next row in Power Query.

How to refer to the next row in Power Query

Power Query previous row value based on criteria!! 😮

Best regards,

Yuliana Gu

[EduFusiger · Accepted solution]

Thanks a lot Yuliana Gu, it worked. I saw a solution yestarday using [column] {[index]} but couldn't do it works. The first article made it easy. 

Best regards,

Eduardo Fusiger