Find Max String / Max Value based on Multiple Columns

[KR300]

Hi team, I want to find the ax Value or string based on the multiple columns ( Except Issue ID Column ). Pls see the below screenshot

Note: It will include Nulls or Blanks or all Strings, anything is poosible those cells but to show Max String /  Max Value ( No Nulls or Blanks in the result Column )

[danextian]

Hi @KR300 

You can use Record.FieldValues(_) in a custom column to return the field values of each row as a list.  Then remove the first item from that list and select nonblank items.

let 
allcolumns = Record.FieldValues(_),
removeIDcolumn = List.Skip(allcolumns, 1),
removeblanks = List.Select(removeIDcolumn, each _ <> null and  _ <> "")
in
List.Max(removeblanks)