Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
You can use Fill Up under Transform Tab on the second column in Query Editor
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
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |