Forum Discussion
Create 8hr Time Band
I am having trouble figuring out the correct formula to create a calculated column to highlight an 8hr band window in which someone would be categorized under. The employee + hour login is provided. The goal is to put them into 8hr band windows.
Any guidance will be greatly appreicated!
Please see below for example.
| Employee | Hour Login | 8Hr Band |
| Karen | 9:00am | 9:00am - 4:00pm |
| Amanda | 5:00pm | 5:00pm - 12:00am |
| Grace | 1:00am | 1:00am - 8:00am |
| Linda | 12:00pm | 9:00am - 4:00pm |
| Sarah | 3:00pm | 9:00am - 4:00pm |
Hi Anonymous,
Do you have pre-determined bands that are always the same? If so, you can use the SWITCH() function to create a calculated column. Here are some details / examples:
https://theexcelclub.com/switch-function-in-dax-for-excel-power-pivot-and-power-bi/
Best,
Bekah
1 Reply
Hi Anonymous,
Do you have pre-determined bands that are always the same? If so, you can use the SWITCH() function to create a calculated column. Here are some details / examples:
https://theexcelclub.com/switch-function-in-dax-for-excel-power-pivot-and-power-bi/
Best,
Bekah