How to get price comparison report

[siroopm2020]

Dear All,

I have a price list from 4 suppliers. 

I want to get the minimum unit price and respective supplier name and the second minimum unit price and respective supplier name as below.

[amitchandak]

@siroopm2020 ,

Unpivot the table in the power query, and then you can create rank for price.

You will have two columns, rename them as Supplier and price

Then create a rank like this

Rank = rankx(filter(Table, [supplier] =earlier([supplier]) && [Product Name] =earlier([Product Name]) ) , [Price],,asc,dense)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[siroopm2020]

https://drive.google.com/file/d/12jN5lcHlobyCtZ4B1x4gsnxHL6EuymDp/view?usp=sharing

[SolomonovAnton · Accepted solution]

hello ! 

you should create calculation column 

in visual table you should in Filter Panel  apply filter RanlColumn = 1 for get Lowest Price 

in visual table you should in Filter Panel  apply filter RanlColumn = 2 for get Second Price 

if I answered at your question please mark topic as resolved 🙂

[siroopm2020]

how to avoid zero values columns while ranking?

[siroopm2020]

Some results are wrong. Barcode 1889648 lowest must be 68, and second lowest 77.40

[siroopm2020]

i corrected it, caz Data Type was text. Now its okey. Thank you.