Forum Discussion
Lookup identical value
Hi, I have two columns, "Assigned to" and "Resolved by". Trying to calculate how many cases the X person got Assigned each day and also how many he Resolved. The name can only be found in column...
Hi, Anonymous
You can try the following methods.
1.Calculated column
Column = IF ( [Assigned to] = [Resolved by], [Assigned to], BLANK () )2. Measure
Measure = IF ( MAX ( 'Table'[Assigned to] ) = MAX ( 'Table'[Resolved by] ), MAX ( 'Table'[Assigned to] ), BLANK () )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
You can try the following methods.
1.Calculated column
Column =
IF ( [Assigned to] = [Resolved by], [Assigned to], BLANK () )
2. Measure
Measure =
IF (
MAX ( 'Table'[Assigned to] ) = MAX ( 'Table'[Resolved by] ),
MAX ( 'Table'[Assigned to] ),
BLANK ()
)
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.