Forum Discussion

Frequent Visitor

8 years ago

Solved

new column to enter data in a range

Hi, New to BI and I am trying to create a new column for sale dates into 4 categories (0-30, 31-60, 61-90, 91+). I have a column of sale days.

Anonymous

8 years ago

Try this

Bucket Range = SWITCH( TRUE(), 
    Table1[Value]<=30,"0-30",
    Table1[Value]<=60,"31-60",
    Table1[Value]<=90,"61-90","91+")

Thanks
Raj

Frequent Visitor

8 years ago

Sample:

I have a column in my master table with sale days but I want to create a new column for sales profile

Sales Days | Sales Profile

7 0-30

55 31-60

95 91+

18 0-30

65 61-90

I have started with: Sales day profile = If([Sales Day]<30,"0-30",0) before I start adding additional criteria.

Thanks for your help.

Anonymous

Not applicable

8 years ago

Try this

Bucket Range = SWITCH( TRUE(), 
    Table1[Value]<=30,"0-30",
    Table1[Value]<=60,"31-60",
    Table1[Value]<=90,"61-90","91+")

Thanks
Raj