Forum Discussion
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. ...
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
= Table.AddColumn(#"Replaced Value8", "Custom", each List.Max(Record.ToList([Col A],[Col B],[Col C])))
i have tried already, It didnt works 😅
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