I got something I was used to doing in Excel, but I really don’t where to start in Power Query.
I have a list of values (3 in this case) in three columns Alpha, Bravo, Charlie.
I need the column name of the maximum value for that row and the maximum value.
I can do it in DAX with some switch instruction, but I think Power Query is the better place.
After I get the max value is there any other option than nested “if then else”?
match_index.xlsx (21.2 KB)