Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone
I have a table
NAME | SCORE1 | SCORE2 | SCOR3 |
JHON | 5 | 4 | 8 |
ANNE | 6 | 6 | 8 |
MARIE | 7 | 5 | 8 |
There are a lot of other column but essentially I just want to get the min Score per row, first row 4, second 6 (what about tie), third 5 in a new column
I've found MIN for both List.Min and Table.Min but I'm not able to get the minimum value per row.
Could you suggest me how I could try to get this?
Thanks so much
Solved! Go to Solution.
you need an 'each' before List.Min
Lol, and now I can now see how much easy is,
Here is the syntax = Table.AddColumn(#"Table", "Custom", each List.Min({ [Scor1], [Score2], [Score3] }))
Thank you very much!!
A column like
List.Min({[SCORE1], [SCORE2], [SCORE3]})
I got error, if wanted a new column, I typed
= Table.AddColumn(#"Table", "Custom", List.Min({ [Scor1], [Score2], [Score3] }))
is it right?
This gives me error
Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?