Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column made up of a Look up value below...
Solved! Go to Solution.
Hi, @dw0120
Based on your description, I created data to reproduce your scenario.The pbix file is attached in the end.
Table1:
Table2:
You may create a calculated column as below.
NewColumn =
var _val = LOOKUPVALUE(Table1[Column1],Table1[Column2],Table2[Column3])
return
IF(
ISBLANK(_val),
LOOKUPVALUE(Table1[Column1],Table1[Column2],Table2[Column4]),
_val
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @dw0120
Based on your description, I created data to reproduce your scenario.The pbix file is attached in the end.
Table1:
Table2:
You may create a calculated column as below.
NewColumn =
var _val = LOOKUPVALUE(Table1[Column1],Table1[Column2],Table2[Column3])
return
IF(
ISBLANK(_val),
LOOKUPVALUE(Table1[Column1],Table1[Column2],Table2[Column4]),
_val
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
use the COALESCE() function.