Return Time with conditions

[Anonymous]

I have two calculated columns that return the count of jobs based on the booking datetime within a 24hour period.

1. JOBS BEFORE 12

=VAR Time1_ = HOUR(FF_Raw_Data[JOB_BOOKING_DATETIME])
VAR Date1_ = INT(FF_Raw_Data[JOB_BOOKING_DATETIME])
RETURN IF(Time1_ < 12, "Yes", "No")

2. JOBS AFTER 12

=VAR Time1_ = HOUR(FF_Raw_Data[JOB_BOOKING_DATETIME])
VAR Date1_ = INT(FF_Raw_Data[JOB_BOOKING_DATETIME])
RETURN IF(Time1_ > 12, "Yes", "No")

I need to edit the measures based on the actual time i.e. if booking datetime >=00:00 midnight and <12pm midday, return YES else NO.

if booking datetime >=12pm and <00:00 midnight, return YES else NO

Appreciate any help, thanks.

[amitchandak]

@Anonymous , I do not think you need a change as <=12 is as good as >0 and < =12

also > 12 is as good as >12 and <=23:59:59

[Fowmy · Accepted solution]

@Anonymous 

Use below calcualted columns:

Jobs Before 12 = 
VAR _HOUR = HOUR(FF_Raw_Data[JOB_BOOKING_DATETIME]) RETURN
IF( _HOUR >= 0 && _HOUR < 12, "YES","NO")

Jobs After 12 = 
VAR _HOUR = HOUR(FF_Raw_Data[JOB_BOOKING_DATETIME]) RETURN
IF( _HOUR >= 12 && _HOUR <= 24, "YES","NO")

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmythat worked perfectly, thank you