NEW! FREE 45 Minutes Excel VBA Loop Course for Beginners Watch now 

Power BITutorials

Learn How to do Reverse Rows Using Power Query

1 Mins read

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.

 

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.

 

AFTER REVERSING ROWS

Acquire More Knowledge Here : 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…