The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@Anonymous , Create measures like
minC = min(Table[Copper COG])
maxC = max(Table[Copper COG])
Range = if([minC] =[maxC], [minC] &"" , [minC] & " - "& [maxC])
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
8 |