Forum Discussion

kap84's avatar
kap84
New Member
3 years ago
Solved

Get value from another table if result from first is empty

Hi   I need to get a name from another table if it's empty on first table, I've tried following as a calculated column but it gives empty result.    FirstName = IF(ISBLANK ( 'Table_A'[FirstName...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    I think with fields of type text, you might need to use IF('Table_A'[FirstName_TableA] = "", ...) as the condition instead. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

What is the common field in both tables (based on which you want to bring overthe first name)?

kap84's avatar
kap84
New Member
3 years ago

They are linked using a 3rd a table

Column ID in table ALL_ID_id06 is used as a slicer on report.