Calculating the lowest value among columns

[Anonymous]

Dear experts,

I am new to Power BI, and I must admit I've been feeling quite stupid.

I was wondering how I can add a fifth column in this table so that I can find the minimum price among the three suppliers.

Thank you very much!

Product Name	Supplier 1	Supplier 2	Supplier 3	Lowest price
Plug	50	30	47	?
Pick	5	3	6	?
String	12	16	18	?

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can unpivot the supplier values:

and this measure:

Measure =

VAR _minPrice = CALCULATE(MIN('Table'[Value]); ALLEXCEPT('Table'; 'Table'[Product Name]))

VAR _tbSupplier = CALCULATETABLE(VALUES('Table'[Supplier]); FILTER(ALLEXCEPT('Table';'Table'[Product Name]); 'Table'[Value] = _minPrice))

RETURN CONCATENATEX(_tbSupplier; 'Table'[Supplier]; ",")

[az38]

Hi @Anonymous 

have a look at the great solution by @Zubair_Muhammad  here https://community.powerbi.com/t5/Desktop/MIN-with-Multiple-Columns/td-p/369307

Column =
VAR temp = { Table1[Supplier 1], Table1[Supplier 2], Table1[Supplier 3] }
RETURN
    MINX ( Temp, [Value] )

[Anonymous]

Thank you very much!!!

[Anonymous]

Thank you very very much!

I was wondering if there is an easier way, or if it is better to add an excel table to the model that will already contain the lowest values and their respective suppliers.

 Best,

MullerBR

[Anonymous]

Hi @camargos88 ,

Whether the Table 2 in the following screen shot is your expected result? If yes, please unpivot these suppliers columns first, then create calculated table with the below formula:

PQuotes = SUMMARIZE('Product quote','Product quote'[Product Name],"SupplierL",CALCULATE(MAX('Product quote'[Attribute]),FILTER('Product quote','Product quote'[Product Name]=EARLIER('Product quote'[Product Name])&&'Product quote'[Value]=MIN('Product quote'[Value]))),"Lowest price",MIN('Product quote'[Value]))

Best Regards

Rena