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
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity 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.