Forum Discussion
michael_knight
Post Prodigy
Post ProdigyReturn largest value
Hi, I'm trying to create a column that will display the largest value offer of a single property This is what it would look like on Excel. It displays the largest Total IN with the Offer Stat...
Not sure if you wanted a column or a measure expression, but here is a column expression that gets your desired results.
Display Offer =
VAR thisoffer = Sheet1[Total IIN]
VAR maxoffer =
CALCULATE (
MAX ( Sheet1[Total IIN] ),
ALLEXCEPT (
Sheet1,
Sheet1[Property]
),
Sheet1[Offer Status] = "Pending"
)
RETURN
IF (
AND (
thisoffer = maxoffer,
Sheet1[Offer Status] = "Pending"
),
thisoffer,
0
)Regards,
Pat
michael_knightPost Prodigy
Post ProdigyThank you guy! Ashish_Mathur Nathaniel_C mahoneypat
Ashish_Mathur
Super User
Super UserYou are welcome. If my reply helped, please mark it as Answer.