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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors