Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating Timebands

Hi I have a column of days worked for employees and i want to group them into Timebands of  less than 3 months,  between 3 and 6 months and greater than 6 months. I think i may need to create new m...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Amy

     

    Apologies for late response - yes that helped! 

     

    thank you so much.

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
7 years ago

Well, it depends on your data structure. In this (rare) case, you may need a calculated column or a conditional column from Power Query.