categorizing based on values

[Vinay06]

hi,

i am new to dax, in data i have values from 1 to 4753 and i want to categorize data into intervals of 1-7,8-15,16-30,31-60,61-90,90-180,>180. how should i do it? please help me

[harshnathani · Accepted solution]

Hi @Vinay06 ,

You can do this in Power Query using Conditional Columns

http://www.plumblineconsulting.com/power-bi-create-buckets-for-continuous-values/

else in DAX use this code:

Group Name =
SWITCH (
    TRUE (),
    Table1[column X] >= 180, ">180",
    Table1[column X] < 180
        && Table1[column X] >= 90, "90-180",
    Table1[column X] < 90
        && Table1[column X] >= 61, "61-90",
    Table1[column X] < 60
        && Table1[column X] >= 31, "31-60",
    Table1[column X] < 30
        && Table1[column X] >= 16, "16-30",
    Table1[column X] < 15
        && Table1[column X] >= 8, "8-15",
    "1-7"
)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Vinay06]

its working,thank you.