Forum Discussion

Helper II

8 years ago

Solved

Time difference between next row

Hi all, I have another question, A want to to count time difference between actual row and next row, when "bit" equals 1, like beneath: Date/Time Bit Time Difference 2018-01-11T17:03...

Need Help

Zubair_Muhammad

8 years ago

pak

May be a MEASURE instead of a column would handle memory better.

Try this MEASURE

Time Difference Measure =
VAR NextRow =
    CALCULATE (
        MIN ( TableName[Date/Time] ),
        FILTER (
            ALL ( TableName ),
            TableName[Date/Time] > SELECTEDVALUE ( TableName[Date/Time] )
        )
    )
RETURN
    IF (
        SELECTEDVALUE ( TableName[Bit] ) = 1,
        DATEDIFF ( SELECTEDVALUE ( TableName[Date/Time] ), NextRow, SECOND )
    )

Zubair_Muhammad

Community Champion

8 years ago

pak

You are adding it as a calculated column.

PLease add it as a MEASURE

Zubair_Muhammad

Community Champion

8 years ago

pak

You can add MEASURE from the MODELLING tab or by right clicking the Table

Then use a Table Visual as shown in the Picture below