IF conditional with several conditions (Values)

[manuelfigueira]

Hello,

I've been trying to create a IF conditional DAX where happen the below:

if X value is between 0 - 30 show me "0 - 30", 

if X value is between 31 - 60 show me "31-60",

If X value is between 61 - 90 show me "61 - 90",

if X value is between 91 - 120 show me 91 - 120"

Any takers? 🙂

Thanks a lot!!

[V-pazhen-msft · Accepted solution]

Hi,

@manuelfigueira 

Switch is used to combine multiple IFs in one neat formula:

Column = SWITCH(TRUE(),

        [Value]>= 0 && [Value]<=30,"0-30",

        [Value]>=31 && [Value]<=60,"31-60",

        [Value]>=61 && [Value]<=90,"61-90",

        [Value]>=91 && [Value]<=120,"91-120"

)  

Paul
Best

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly, Kudos is nice too.

[Tahreem24]

Create a calculated column using switch like below :

Column=SWITCH(Table[Column X], "0-30","0-30","31-60","31-60","61-90","61-90","91-120","91-120")

Please give Kudos and accept this as a solution if it helps you.

[Tahreem24 · Accepted solution]

@manuelfigueira ,

I thought earlier your Column X is Text value. If it is Numeric or whole value so make little changes in earlier posted Calculated Column:

Calculated Column = SWITCH(Table1[Column X],

                                 AND([Column X]>=0,[Column X]<30),"0-30",

                                AND([Column X]>=31,[Column X]<60),"31-60",

                                 AND([Column X]>=61,[Column X]<90),"61-90",

                                 AND([Column X]>=91,[Column X]<120),"91-120")

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

[manuelfigueira]

Hi Tahreem,

Thank you for your answer! I tried it but it says this "Function 'SWITCH' does not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

I was thinking if is possible using something like Formula = If([Age] => 0 but < 30, "0-30"........ and so on! 

Do you thik that's possible?

Thanks a lot!!

[V-pazhen-msft · Accepted solution]

Hi,

@manuelfigueira 

Switch is used to combine multiple IFs in one neat formula:

Column = SWITCH(TRUE(),

        [Value]>= 0 && [Value]<=30,"0-30",

        [Value]>=31 && [Value]<=60,"31-60",

        [Value]>=61 && [Value]<=90,"61-90",

        [Value]>=91 && [Value]<=120,"91-120"

)  

Paul
Best

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly, Kudos is nice too.