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

Community Champion

8 years ago

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

vee_ngoru
New Member
4 years ago
Tried this it didn't give me the correct bucket ranges.