Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure - Normal Hours or OOH

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, 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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.

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      4 years ago
      Chk = 
VAR __dt = MAX( 'Table'[Date] )
VAR __t = TIMEVALUE( __dt )
RETURN
    IF( WEEKDAY( __dt ) < 6 && __t >= 8 / 24 && __t <= 17 / 24, "Normal", "OOH" )