topic Re: Get minimum value from a table in DAX Commands and Tips

Get minimum value from a table

jlarques — Thu, 08 Oct 2020 14:23:03 GMT

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

Re: Get minimum value from a table

amitchandak — Thu, 08 Oct 2020 15:45:05 GMT

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.

Re: Get minimum value from a table

jlarques — Thu, 08 Oct 2020 15:58:49 GMT

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.