Classify number of days

[joshua1990]

Hi all!

I have a column that contains a number. This number represents the number of days:

Days

1

12

5

25

Now I would like to place next to this column  a calculated column that translates this numbers into this groups:

• 5 Days (>=0 & <=5 )
• 10 Days (>=6 & <=10 )
• 20 Days (>=11 & <=20 )
• etc.

For this I would take a long IF Statement. Is there any alternative?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but  I think one of ways to solve it is, and I suggest, having a Grouping Table like below.

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

It is for creating a calculated column.

Group CC = 
SUMMARIZE (
    FILTER (
        'Grouping',
        'Grouping'[Min] <= Data[Days]
            && OR ( 'Grouping'[Max] >= Data[Days], 'Grouping'[Max] = BLANK () )
    ),
    'Grouping'[Group]
)