Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Maximum value of two measures

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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]))

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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
Solution Sage
Solution Sage

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

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.