Calculate time bigger then ...

[RvdHeijden]

I have a simple question at least i hope so.

I have a table with a column in it called 'Technisch gereed' which has data/time values

for example "13-11-2017 13:00:00" or "7-11-2017 20:57:00"

My question is that i want to calculate the number of rows where the time in 'Technische gereed' is > 16:30:00

Basically i want to now (per row) how many times a tickets is solved after workinghours.

[Zubair_Muhammad]

HI @RvdHeijden

May be this MEASURE

Count =
COUNTROWS (
    FILTER (
        TableName,
        TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
            > TIME ( 16, 30, 0 )
    )
)

[RvdHeijden]

@Zubair_Muhammad

thanks for the info but i would rather have a calculated column so that i can use a linegraph to display the result

[Zubair_Muhammad]

Hi @RvdHeijden

Do you simply need True or False in the Column?

Column =
IF (
    TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
        > TIME ( 16, 30, 0 ),
    TRUE (),
    FALSE ()
)

[MarcelBeug · Accepted solution]

@Zubair_Muhammad just a small remark: a formula like if condition then true else false can be shortened to just condition.

Applied to your formula:

Column =
    TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
        > TIME ( 16, 30, 0 )