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)
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
I have started with: Sales day profile = If([Sales Day]<30,"0-30",0) before I start adding additional criteria.
Thanks for your help.