topic Re: IF-ELSE in DAX Commands and Tips

IF-ELSE

Anonymous_ — Wed, 08 Feb 2023 09:38:17 GMT

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 mark them as 'h' or If my input is not 'a','b' or 'c', then rename them as 'h'.

Output -

How do I do this using DAX in an efficient manner?

Thanks for the help!:)

P.S: There are many more rows with different that need to be defined under 'h', values for 'a','b' and 'c' are same everywhere.

Re: IF-ELSE

AilleryO — Wed, 08 Feb 2023 09:40:57 GMT

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

Re: IF-ELSE

FreemanZ — Wed, 08 Feb 2023 10:23:10 GMT

hi Anonymous_

try like:

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

Re: IF-ELSE

Anonymous_ — Tue, 21 Feb 2023 04:34:42 GMT

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

Re: IF-ELSE

BrianConnelly — Tue, 21 Feb 2023 04:39:10 GMT

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