Min value from other columns

[Anonymous]

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

[jthomson]

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

[ryan_mayu]

@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]))))

[Anonymous]

@ryan_mayu 

I want to creat a  custom column. 

[jthomson]

Oh, you want a Power Query solution?

[Anonymous]

@Anonymous 

You can use MIN function to get the lowest value from other columns while creating a new column-

Column = MIN('TableName'[ColumnName])

Appreciate your kudos !! Please mark my post as solution if this helps you.