HiI 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 measures but i am not sure of the formula needed. any ideas?

Hi Amy Apologies for late response - yes that helped! thank you so much.

Creating Timebands | Microsoft Fabric Community

MattAllington
Community 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.
v-xicai
Community Support
7 years ago
Hi Anonymous ,

You can create measure using DAX below.

Range Judge = SWITCH(TRUE(),MAX(Table1[days])<=90,"less than 3 months", MAX(Table1[days])>90&&MAX(Table1[days])<=180,"between 3 and 6 months", MAX(Table1[days])>180,"greater than 6 months")

Best Regards,
Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xicai
Community Support
7 years ago
Hi Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards
Amy Cai
- Anonymous
  Not applicable
  7 years ago
  Hi Amy
  
  Apologies for late response - yes that helped!
  
  thank you so much.