If you have been using the MICROSOFT EXCEL software for some time, you must have heard or read about the word POWER QUERY.
POWER QUERY IS A DATA SHAPING TOOL WHERE WE CAN BRING THE DATA THROUGH A CONNECTION FROM VARIOUS SOURCES, DO SOME SHAPING SUCH AS REMOVING ROWS, COLUMNS, CHANGING DATA TYPES, TRIMMING THE DATA ETC. AND GET IT FINALLY FOR THE ANALYSIS IN OUR MAIN SOFTWARE SUCH AS MICROSOFT EXCEL OR MICROSOFT POWER BI .
FOR THE INTRODUCTION OF POWER QUERY, CLICK HERE.
Power Query tool, in fact, has immense powers to shape up the data in the way we want.
We’ll cover a lot of practical problems to sort them out with the help of the POWER QUERY.
In this article, we would learn how to REVERSE THE ROWS using POWER QUERY in Excel or POWER BI.
With the reversal of rows we mean to reverse the sequence of the rows.
E.g.
If we have any data in a pattern like
ROW 1
ROW 2
ROW 3
We want to reverse it and create the table in the sequence as
ROW 3
ROW 2
ROW 1
Let us understand how we can do that in POWER QUERY.