Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to get the maximum value of two measures in Power BI?
Solved! Go to Solution.
Measure
Measure 3 = if(max(Sales[Sales])>max(Sales[COGS]),max(Sales[Sales]),max(Sales[COGS]))
Column
Col3 = if((Sales[Sales])>(Sales[COGS]),(Sales[Sales]),(Sales[COGS]))
Measure
Measure 3 = if(max(Sales[Sales])>max(Sales[COGS]),max(Sales[Sales]),max(Sales[COGS]))
Column
Col3 = if((Sales[Sales])>(Sales[COGS]),(Sales[Sales]),(Sales[COGS]))
Yes we can but do explain the scenario for better understanding and confirmation
@AnkitBI I have measure which gives me the weekly maximum of the daily average for a department and another measure which does the same for another department. I wanted to do a comparison of the weekly maximum values and get the maximum out of the both values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |