IF Formula Help

[Anonymous]

Hi.

I am trying to categorise numerial responses into 3 different categories.

If they answered betweeb 0-1 - I want to categorise that as 0-1 Day Active

If they answered between 2-4 - I want to categorise that as 2-4 Days Active

If they answered between 5-7 - I want to categorise that as 5+ Days Active

See the example of my data set below, the column in bold is what I need.

Name	Answer	Catergory
Mary	2	2-4 Active
Joe	5	5+ Active

I have tried the below DAX but its coming up as error:

Cat@REG = IF(Table1[Answer]="","",IF(Table1[Answer]>4,"5+Active",IF(Table1[Answer]>1,"2-4 Active","0-1 Active")))

[Anonymous]

Thank you to you both. This really is a great community!

[Fowmy]

@Anonymous 

Add the column as 

Column = 
var __v = Table1[Answer] return
SWITCH( 
    TRUE(),
    __v >= 0 && __v <=1 , "0-1 Day Active",
    __v >= 2 && __v <=4 , "2-4 Days Active",
    __v >= 5, "5 Days Active"
)
    

[negi007 · Accepted solution]

@Anonymous in this case you will need to create a calculated column like below in your data

Ans_Cat = if ('Table'[Answer] <=1, "0-1 Active", IF(AND('Table'[Answer] >=2,'Table'[Answer] <=4), "2-4 Active", "5+ Active"))

let me know if it works for you. thanks