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 ...
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

     

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident 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