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

AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
3 years ago

Hi,

Not 100% sure of your request but I'll give a try :
Test Column = IF ( [ColumName] IN {"d","e","f"}, "h" )

If you have many tests, you should consider using SWITCH function,

or if you have many many tests, even consider in making a correpondance table and use merge of queries.

Hope it helps, let us know