Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
9 | |
8 | |
7 | |
7 |