Get minimum value from a table

[jlarques]

Dear all,

I have a table with:

• Petrol product
• Petrol supplier
• Price
• Petrol type

I have another table with cars that contain a column with Petrol type. I want that when the user chooses a car, I can show it the lowest price, Petrol product and Petrol supplier to recommend it for this car.

I tried with ROW, SELECTCOLUMNS and other DAX instructions but anything works.

Do you know how can I do it?

Thanks, everyone for your help!

Regards,

José Luis

[amitchandak]

@jlarques ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[jlarques]

Hi @amitchandak ,

here you can see two pictures. One is the Petrol table and the other one is the result that I want to get it(it's in a square to the left side in white, depending on what car the user chooses.

Thanks for your help.