Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Nested If DAX error in calculated column

Hi Experts

 

cannot see where i have made my error - with the following dax 

New = IF('Master Call Quality Table'[Form Component Title] = "Experience", [Answer Title] ||
        IF('Master Call Quality Table'[Form Component Title] = "Contact Medium", [Answer Title], BLANK()))
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, Anonymous 

    try below

     

    IF(
 'Master Call Quality Table'[Form Component Title] = "Experience" ||
 'Master Call Quality Table'[Form Component Title] = "Contact Medium",
 [Answer Title],
 BLANK()
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

1 Reply

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, Anonymous 

    try below

     

    IF(
 'Master Call Quality Table'[Form Component Title] = "Experience" ||
 'Master Call Quality Table'[Form Component Title] = "Contact Medium",
 [Answer Title],
 BLANK()
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly