Measure - Normal Hours or OOH

[Anonymous]

Hello,

Is there a measure or DAX I can use to find out if something has been raised in hours or out of hours please?

Normal - Monday - Friday 8am-5pm

OOH - Monday - Friday 5pm - 8am & Saturday - Sunday - All Day

Thanks, 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try this measure.

Normal Hours or OOH =
VAR _date =
    MAX ( 'Table'[Date] )
VAR _hour =
    HOUR ( _date )
VAR _min =
    MINUTE ( _date )
VAR _sec =
    SECOND ( _date )
VAR _time =
    TIME ( _hour, _min, _sec )
RETURN
    IF (
        WEEKDAY ( _date, 2 ) IN { 6, 7 },
        "OOH",
        IF ( TIME ( 8, 0, 0 ) < _time && _time < TIME ( 17, 0, 0 ), "Normal", "OOH" )
    )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

Chk = 
VAR __dt = MAX( 'Table'[Date] )
VAR __t = TIMEVALUE( __dt )
RETURN
    IF( WEEKDAY( __dt ) < 6 && __t >= 8 / 24 && __t <= 17 / 24, "Normal", "OOH" )

[Anonymous]

Hello Stephen,

Thank you for helping, unfortunatley its now showing everything as OOH? I've change the date from table to 'Task Created Date' Would this be an issue? Thanks again! 

  

[Anonymous]

Hi @Anonymous ,

I guess you have a problem with the underline here, you don't need to add ".Date".

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.