Forum Discussion
Solved
Highest value by column
Hi everybody, I'm stuck at the following problem. I have to select the highest score out of six columns and return the column name of the highest score. The table should look like this: R1 R...
Bauhaus-Arti you can try nested if function like below to get maximum value
Maximum = MAX('Table'[R1],MAX('Table'[R2],MAX('Table'[R3],MAX('Table'[R4],MAX('Table'[R5],'Table'[R6])))))
Anonymous They dont show up in the query editor because R1 to R6 are calculated columns. Any idea how i can fix this?
Bauhaus-Arti you can try nested if function like below to get maximum value
Maximum = MAX('Table'[R1],MAX('Table'[R2],MAX('Table'[R3],MAX('Table'[R4],MAX('Table'[R5],'Table'[R6])))))