Forum Discussion

KR300's avatar
KR300
Helper III
1 year ago

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 is poosible those cells but to show Max String /  Max Value ( No Nulls or Blanks in the result Column )

Interesting Links
Need Help
Show and Tell

1 Reply

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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)