New Column based on lowest value from other columns

[Gerald23]

Hi Everyone,

I would like to add a new column to my data in Power BI. This New column should contain the lowest value (But not Blank or empty values) from multiple columns.

 For example my table looks like this:

Article Nbr	Price 1	Price 2	Price 3	Price 4
123456	1.01	1.05	1.20	3.70
456789	2.50		3.16	4.19
321654	1.23	0.98	3.04
987654		1.52	5.61	2.87

And i would like to add a calculated column so that the table will look like this:

Article Nbr	Price 1	Price 2	Price 3	Price 4	New Column
123456	1.01	1.05	1.20	3.70	1.01
456789	2.50		3.16	4.19	2.50
321654	1.23	0.98	3.04		0.98
987654		1.52	5.61	2.87	1.52

[johnt75 · Accepted solution]

You could try

Min value = MINX( { 'Table'[Price 1], 'Table'[Price 2], 'Table'[Price 3], 'Table'[Price 4]}, [Value])

[Gerald23]

Perfect that works 😀