Forum Discussion
check duration time
Hi Every One, I want to check if the duration hours between ( 3:55 and 4:15 ) return true otherwise return false using DAX, the column that I want to check for it in the below image ...
Hi Anonymous
If the 'Duration - Time' column is of data type Time, try this for your new calculated column:
NewColumn = IF ( Table1[Duration - Time] >= TIME ( 3, 55, 00 ) && Table1[Duration - Time] <= TIME ( 4, 15, 00 ); TRUE (), FALSE () )You might have to update the conditions depending on whether you want to exclude or include the edge values (3:55 and 4:15)
Hi Anonymous
If the 'Duration - Time' column is of data type Time, try this for your new calculated column:
NewColumn =
IF (
Table1[Duration - Time] >= TIME ( 3, 55, 00 )
&& Table1[Duration - Time] <= TIME ( 4, 15, 00 );
TRUE (),
FALSE ()
)
You might have to update the conditions depending on whether you want to exclude or include the edge values (3:55 and 4:15)