Forum Discussion

Kate_D's avatar
Kate_D
Frequent Visitor
2 years ago
Solved

Calculated Column using RELATED

Hello. I need help with a calculated column. It returns a row with a manager’s name and a row with blank value when adding to a table.   Manager Name = IF('Department [Column.ManagerId] = RELATED('...
Need Help
  • Kate_D's avatar
    Kate_D
    2 years ago

    solved

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

Kate_D it will be easier to share raw data for department and employee to understand why you are getting blank value. DAX expression seems to be correct and should work, only reason it will return empty value if the column value doesn't match.

  • Kate_D's avatar
    Kate_D
    Frequent Visitor
    2 years ago

    I can't share the raw data. Thank you