Forum Discussion

jakoob's avatar
jakoob
Frequent Visitor
3 years ago
Solved

Calculated Column Based on Time

Hi,   I'm new to DAX and im having some trouble with creating a calculated colum based off the time stamp of a row.   I have some data that looks like this: Ticket ID Create Date/Time 1 ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi jakoob 

    Please try

    Created On Hours =
    IF (
    AND (
    TIMEVALUE ( 'Ticket Data'[Date/Time] ) > TIME ( 08, 29, 00 ),
    TIMEVALUE ( 'Ticket Data'[Date/Time] ) < TIME ( 17, 00, 00 )
    ),
    "Yes",
    "No"
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi jakoob 

Please try

Created On Hours =
IF (
AND (
TIMEVALUE ( 'Ticket Data'[Date/Time] ) > TIME ( 08, 29, 00 ),
TIMEVALUE ( 'Ticket Data'[Date/Time] ) < TIME ( 17, 00, 00 )
),
"Yes",
"No"
)

jakoob's avatar
jakoob
Frequent Visitor
3 years ago

Thank you so much! Works perfectly!