Forum Discussion
Find Max String / Max Value based on Multiple Columns
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 i...
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)