Forum Discussion
Get minimum value from a table
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
2 Replies
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.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.
