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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Finding Min/Max value and display it as a range

Hey Guys ,
I need to display the min and max values as range for instance - .25 to .46 . and if min = max then the vlaue should be displayed as single . I have already calculated min/max values per category . Can you please help
Please see the input table :

bhawna_aashri_0-1605858593550.png

And the out put should be as 

bhawna_aashri_1-1605858658914.png

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Create measures like

minC = min(Table[Copper COG])


maxC = max(Table[Copper COG])

 

Range = if([minC] =[maxC], [minC] &"" , [minC] & " - "& [maxC])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.