Forum Discussion

DeanM's avatar
DeanM
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's avatar
    Anonymous
    8 years ago

    Hi

     

    Try this

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


    Thanks
    Raj

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Try this

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


Thanks
Raj

 

DeanM's avatar
DeanM
Frequent Visitor
8 years ago

Raj, Thanks so much. It works.