Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I tried to use MIN function with multiple columns but unfortunately the MIN is only applicable on "one column",
I don't know how make it work with more than one columns
Example:
First Column: with Value 1
Second Column: with Value 5
Third Column: with Value 4
How can I get Minimum value from all 3 columns.
Solved! Go to Solution.
Hi @mohamed901,
As you want to return minimum value of three columns, you can create a measure like below:
Measure = var m= IF(MIN('Table1'[Column1])<=MIN('Table1'[Column2]),MIN('Table1'[Column1]),MIN('Table1'[Column2])) return IF(m<=MIN('Table1'[Column3]),m,MIN('Table1'[Column3]))
For more information, see attached .pbix file.
Best Regards,
Qiuyun Yu
Hi @mohamed901,
As you want to return minimum value of three columns, you can create a measure like below:
Measure = var m= IF(MIN('Table1'[Column1])<=MIN('Table1'[Column2]),MIN('Table1'[Column1]),MIN('Table1'[Column2])) return IF(m<=MIN('Table1'[Column3]),m,MIN('Table1'[Column3]))
For more information, see attached .pbix file.
Best Regards,
Qiuyun Yu
Hi @v-qiuyu-msft! Thanks for this I have the same issue, thus I have 10-12 columns. Can I do something similar with more than three columns?
Thanks
Kristoffer
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |