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 .
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.
If we have any data in a pattern like
We want to reverse it and create the table in the sequence as
Let us understand how we can do that in POWER QUERY.
For the example, we are going to take an Excel Sheet containing fictitious table just to understand how we can reverse the rows.
We have already performed a few steps which can be learnt here. [ www.gyankosh.net/powerbi ]
The following picture shows the data as it enters the POWER QUERY EDITOR
STEPS TO REVERSE A TABLE IN POWER QUERY EDITOR:
So, we have successfully reversed the rows of a data table in power query which can be further used in Excel or power bi.
In the animated picture above, we show the use of REVERSE ROWS function and then clicking it again the rows are again brought to the previous original sequence.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE