Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |