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.