fbpx

Learn How to do Reverse Rows Using Power Query

Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse rows without Power Query in Power BI. Power Query can do it in a fraction of second without losing any valuable information.

MICROSOFT POWER QUERY FOR BEGINNERS
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

Reverse Rows By Power Query

Let’s take an example where you have a data table showing the result for temperature and time as shown in the picture below.

BEFORE REVERSING ROWS

Step1: To reverse the rows of the data table, perform the below step

Go to Transform > Reverse Rows

BEFORE REVERSING ROWS

Step 2: Close & Apply

This will reverse all the rows as shown in the picture below. After you finish your task click on Close & Apply button to save the changes for later.

MICROSOFT POWER QUERY TRAINING
• 100+ Video Tutorials • 15 Case Studies • 2 eBooks • 10 Presentation Decks • 2 Webinar • 24*7 Dedicated Support

 

AFTER REVERSING ROWS

Acquire More Knowledge Here :