Finding Min/Max value and display it as a range

Anonymous — Fri, 20 Nov 2020 07:52:30 GMT

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 :

And the out put should be as

Re: Finding Min/Max value and display it as a range

amitchandak — Fri, 20 Nov 2020 08:20:47 GMT

Anonymous , Create measures like

minC = min(Table[Copper COG])

maxC = max(Table[Copper COG])

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

topic Re: Finding Min/Max value and display it as a range in DAX Commands and Tips

Finding Min/Max value and display it as a range

Re: Finding Min/Max value and display it as a range