Forum Discussion

Anonymous_'s avatar
Anonymous_
Frequent Visitor
3 years ago
Solved

IF-ELSE

My Input is like so:  I need to define 'd', 'e' and 'f' under a singular category and let everything else remain the same. So, somthing like If input is 'a', 'b' and 'c', then no change else m...
DAX
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous_ 

    try like:

    Column = IF ( [ColumName] IN {"a","b","c"}, [ColumName], "h" )

Anonymous_'s avatar
Anonymous_
Frequent Visitor
3 years ago

Thank you so much! The solution above worked, the [ColumnName] before, "h" is necessary to complete the query 🙂