Skip to main content
cancel
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

Reply
Anonymous
Not applicable

Look up min and max values

Hi 

 

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

 

3 REPLIES 3
gpoggi
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:

rightarrowpbi.png

 

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

 

menupbi.png

 

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

resultpbi.png

 

 

Hope this helps,

 

 

Regards,

 

Gian Carlo Poggi

 

 

 

 

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

JosefPrakljacic
Solution Sage
Solution Sage

Hello Tash/ @Anonymous ,

 

you could use this approach to create your table

EndTable =
SUMMARIZE (
    CustomerRates,
    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!

BR,
Josef

Helpful resources

Announcements
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.