Forum Discussion
Using LOOKUPVALUE with multiple conditions, returns one value if only one condition met
You can try to add a conditional 'location' variable in your calculated column.
Something along the lines of...Average =
var _location =
IF(
ISBLANK(
LOOKUPVALUE('Table A'[Location], 'Table A'[Name], 'Table B'[Name], 'Table A'[Location], 'Table B'[Location])
),
"Other",
[Location]
)
Return
LOOKUPVALUE(
'Table A'[Avg],
'Table A'[Name], 'Table B'[Name],
'Table A'[Location], _location
)Basically you are performing the lookup twice. The first time to see if the location returns a blank. The second time returns the rework time using 'Other' if needed.
You can try to add a conditional 'location' variable in your calculated column.
Something along the lines of...
Average =
var _location =
IF(
ISBLANK(
LOOKUPVALUE('Table A'[Location], 'Table A'[Name], 'Table B'[Name], 'Table A'[Location], 'Table B'[Location])
),
"Other",
[Location]
)
Return
LOOKUPVALUE(
'Table A'[Avg],
'Table A'[Name], 'Table B'[Name],
'Table A'[Location], _location
)
Basically you are performing the lookup twice. The first time to see if the location returns a blank. The second time returns the rework time using 'Other' if needed.
Never mind! I see where my mistake was, you were just shortening some of the variables I had given you and the variables from the two tables were differing in my formula.
This solution worked quite well for what I needed it for. Thank you!