Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi , I need to create a custom column, which gives the lowest value from other columns.
Class | Column_1 | Column_2 | Column_3 | Required_Results |
A | 1 | 1 | 6 | 1 |
B | 2 | 5 | 2 | |
C | 2 | 1 | 5 | 1 |
D | 4 | 3 | 2 | 2 |
E | 5 | 2 | 2 | 2 |
F | 6 | 4 | 4 |
Please help me
https://community.powerbi.com/t5/Desktop/MIN-exlude-blanks/td-p/404231
That's for two columns and handles the blank values you have - you should be able to expand that logic to a third column from there
@Anonymous
you can try this
Column = if(ISBLANK('Table'[Column1]),min('Table'[Column2],'Table'[Column3]),if(ISBLANK('Table'[Column2]),min('Table'[Column1],'Table'[Column3]),if(ISBLANK('Table'[Column3]),min('Table'[Column1],'Table'[Column2]),min(min('Table'[Column1],'Table'[Column2]),'Table'[Column3]))))
Proud to be a Super User!
Oh, you want a Power Query solution?
@Anonymous
You can use MIN function to get the lowest value from other columns while creating a new column-
User | Count |
---|---|
92 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |