Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get max value for different column.

Dear Power Bi Community,   Could you please help me to to get max value for Col Max like this in power bi? I have tried several time but the max value I got is 98 for each rows, which is wrong.   ...
Need Help
  • Thingsclump's avatar
    Thingsclump
    4 years ago

    Hey Anonymous 

     

    The first solution works only if you want to select max of all columns.

     

    If you want to choose columns try this.

     

    =List.Max(Record.ToList(Record.SelectFields(_,{"Col A","Col B","Col C"}))))

     

     

    I will wait to see how this works. Accept it as a solution if this works as expected.

     

    Thanks

Thingsclump's avatar
Thingsclump
Resolver V
4 years ago

Hi Anonymous 

 

For the table you have shown , you can add a custom column as below

 

=List.Max(Record.ToList(_))

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

= Table.AddColumn(#"Replaced Value8", "Custom", each List.Max(Record.ToList([Col A],[Col B],[Col C])))

 

i have tried already, It didnt works ðŸ˜…

  • Thingsclump's avatar
    Thingsclump
    Resolver V
    4 years ago

    Hey Anonymous 

     

    The first solution works only if you want to select max of all columns.

     

    If you want to choose columns try this.

     

    =List.Max(Record.ToList(Record.SelectFields(_,{"Col A","Col B","Col C"}))))

     

     

    I will wait to see how this works. Accept it as a solution if this works as expected.

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey there. Thingsclump solution does work. Don't replace anything; the  (_) means "the current record, i.e "this row's values. Don't replace that with column names, since you are searching the whole row.

     

    --Nate