Forum Discussion
Time Tracking with time group
Hi BI Community Team,
As per expectation result, we want to know the earliest of check-in time and latest of check-out time by time group as the screenshot below:
So, we have tired the new column with measure below.
5 Replies
- AmiraBedhSuper User
I adjusted your dax code to the following :
Time_Group2 = SWITCH( TRUE(), ISBLANK([Check-Out]), SWITCH( TRUE(), [Check-In] >= TIME(1, 0, 0) && [Check-In] < TIME(8, 0, 0), "Early Morning", [Check-In] >= TIME(8, 0, 0) && [Check-In] < TIME(12, 0, 0), "Morning", [Check-In] >= TIME(12, 0, 0) && [Check-In] < TIME(13, 30, 0), "Lunch", [Check-In] >= TIME(13, 30, 0) && [Check-In] < TIME(17, 30, 0), "Afternoon", [Check-In] >= TIME(17, 30, 0) && [Check-In] < TIME(21, 0, 0), "Evening", "Late Evening" ), [Check-In] >= TIME(1, 0, 0) && [Check-Out] < TIME(8, 0, 0), "Early Morning", [Check-In] >= TIME(8, 0, 0) && [Check-Out] < TIME(12, 0, 0), "Morning", [Check-In] >= TIME(12, 0, 0) && [Check-Out] < TIME(13, 30, 0), "Lunch", [Check-In] >= TIME(13, 30, 0) && [Check-Out] < TIME(17, 30, 0), "Afternoon", [Check-In] >= TIME(17, 30, 0) && [Check-Out] < TIME(21, 0, 0), "Evening", "Late Evening" )The code you provided doesn't handle the case where the "Check-Out" value is blank. In your provided logic, you directly compare "Check-In" and "Check-Out" times without considering the scenario when "Check-Out" is blank.
Since the code does not include any conditional check to handle a blank "Check-Out" value, it may lead to incorrect results in that specific case. If "Check-Out" is blank, the code does not have any instruction on how to handle that scenario, so it may lead to wrong categorizations or unexpected results.