Creating Timebands

[Anonymous]

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

any ideas?

[v-xicai]

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 · Accepted solution]

Hi Amy

Apologies for late response - yes that helped! 

thank you so much.

[v-xicai]

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.

[MattAllington]

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