Trick 013 Compare the upper and lower rows with power query

 To compare the value of two rows in Excel. With a simple excel sheet, we can use functions in excel to compare or rotate rows into columns. When we rotate rows into columns, we can easily compare two columns with each other

But for complex tables that we can't use with normal functions in excel or we can't rotate the table vertically, here is an example where we can compare two rows by power query.

With the comparison of the top row and bottom row together, we can apply it to a lot of jobs such as: Comparing the population change between last year and this year or comparing revenue between last month and this month. ...

Link download.