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" )

BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

If statements are good, but dont give you the ability to cleanly expand. I would go with something similiar to Freeman, but as such...

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

You can keep adding rules.....

Column = 
SWITCH(TRUE()
, IF ( [ColumName] IN {"a","b","c"}, [ColumName]
, IF ( [ColumName] IN {"e","f"}, "g"
, "h" 
)