categorizing based on values

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)