Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors