new column to enter data in a range

[DeanM]

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.

[rajendran]

Conditional column is the way to do in power Query, as suggested by @PattemManohar.

Alternatively, You can do this as calculated column in Power BI model as well. Go to Modelling Tab -> New column-> Write your DAX formula here. ( IF (<con1> , "0-30",<Con2>,"31-60" , etc)

Thanks

Raj

[DeanM]

In Power BI I have a column sales days ranging from 0-500.  I need a formula for the new column sales profile 0-30, 31-60, 61-90, 90+.  Keep getting errors.

[rajendran]

What formula you use? Show your sample data and formula you are trying.

Thanks

Raj

[DeanM]

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.

[rajendran · Accepted solution]

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]

Raj, Thanks so much. It works.

[PattemManohar]

Try using "Conditional Column" under Power Query Editor, where you can define your ranges using IF Clause.

[vee_ngoru]

Tried this it didn't give me the correct bucket ranges.