cancel
Showing results for
Did you mean:
Helper IV

## Time Format Boolean Column

Hi,

I have created a calculated column to show if certain end time (format 09:20) is false between certain ranges.

DAX used

7AM-10am = IF(HOUR(dilo_master[end_time]) >= 7 && HOUR(dilo_master[end_time]) <= 10.00 ,TRUE(),FALSE())

I want this measure to state True if the time range is between 7:00am - 10:00am. This measure is still picking up end time values up to 10:59am.

Any ideas on how to cut this off at 10am?
1 ACCEPTED SOLUTION
Super User

I assumed your end time column was a Time column, but is it a DateTime?  If so, you'll have to get the time component from it like this.  You should consider splitting DateTime columns if not already.

7AM-10am =
VAR vTime =
TIME ( HOUR ( dilo_master[end_time] )MINUTE ( dilo_master[end_time] )SECOND ( dilo_master[end_time] ) )
RETURN
IF (
vTime >= TIME ( 700 )
&& vTime <= TIME ( 1000 ),
TRUE (),
FALSE ()
)

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

4 REPLIES 4
Super User

7AM-10am = IF(dilo_master[end_time] >= TIME(7,0,0) && dilo_master[end_time] <= TIME(10,0,0) ,TRUE(),FALSE())

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Helper IV

This has returned FALSE for every row. I have tried changing my end time column format between long and short time but this has not changed the output.

Thanks,

Elliot

Super User

I assumed your end time column was a Time column, but is it a DateTime?  If so, you'll have to get the time component from it like this.  You should consider splitting DateTime columns if not already.

7AM-10am =
VAR vTime =
TIME ( HOUR ( dilo_master[end_time] )MINUTE ( dilo_master[end_time] )SECOND ( dilo_master[end_time] ) )
RETURN
IF (
vTime >= TIME ( 700 )
&& vTime <= TIME ( 1000 ),
TRUE (),
FALSE ()
)

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Helper IV

Thats perfect. Thank you!

Announcements

#### Launching new user group features

Learn how to create your own user groups today!