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)
3 Replies
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)