Maximum value of two measures

[Anonymous]

Is it possible to get the maximum value of two measures in Power BI?

[amitchandak · Accepted 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]))

[AnkitBI]

Yes we can but do explain the scenario for better understanding and confirmation

[Anonymous]

@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.