Forum Discussion
New Column with Max Value
- 5 years ago
Here is a calculated column expression with one way to do it to get the result below. It isn't random but gets the first name alphabetically for each team.
Contact =
VAR thisemployee = Teams[Employee]
VAR firstemployee =
CALCULATE (
MIN ( Teams[Employee] ),
ALLEXCEPT (
Teams,
Teams[Team]
)
)
RETURN
IF (
Teams[Team] = "",
Teams[Employee],
IF (
thisemployee = firstemployee,
firstemployee,
BLANK ()
)
)Regards,
Pat
Here is a calculated column expression with one way to do it to get the result below. It isn't random but gets the first name alphabetically for each team.
Contact =
VAR thisemployee = Teams[Employee]
VAR firstemployee =
CALCULATE (
MIN ( Teams[Employee] ),
ALLEXCEPT (
Teams,
Teams[Team]
)
)
RETURN
IF (
Teams[Team] = "",
Teams[Employee],
IF (
thisemployee = firstemployee,
firstemployee,
BLANK ()
)
)
Regards,
Pat
Thank you so much!