Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!