Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Look up min and max values



Im pretty new to POwer Bi and am having trouble getting this simple DAX to work, please help!


I have a table of customer rates for different tariffs:

CustomerTariff TypeRate
ABC Ltd1 $   50.00
CDE Ltd1 $   60.00
EFG Ltd1 $   70.00
ABC Ltd2 $   20.00
CDE Ltd2 $   30.00
EFG Ltd2 $   40.00
ABC Ltd3 $ 100.00
CDE Ltd3 $ 120.00
EFG Ltd3

 $ 130.00


Then I have another table where I want columns to return the min and max amounts for each tariff to show like this:


Tariff TypeMin RateMax Rate
1 $   50.00 $   70.00
2 $   20.00 $   40.00
3 $ 100.00 $ 130.00


Could someone help me with the dax formula to lookup the min/max value based on the Tariff Type. Im sure its easy, its elluding me though!


Thanks Tash


Responsive Resident
Responsive Resident

Hi @Anonymous ,


In fact, you don't need a DAX formula, you can get it by drag and drop Tariff Type to the table visualization and then drag and drop Rate column two times, and then just click in the rigth arrow:



Then just select Minimum operation for first Rate, and the Maximum operation for the second Rate:




and that's it you will get your desired table:




Hope this helps,





Gian Carlo Poggi





Yes you are right @gpoggi sometimes dax would be an overkill if you just want a simple table visual 😛

Solution Sage
Solution Sage

Hello Tash/ @Anonymous ,


you could use this approach to create your table

EndTable =
    CustomerRates[Tariff Type],
    "Min Rate", MIN ( CustomerRates[Rate] ),
    "Max Rate", MAX ( CustomerRates[Rate] )

Here you have an example file


If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.