Differnce Between two time Values , same Column

Hi Anonymous ,

Thanks for your reply, you can try to see if you are using measure instead of column. This might solve your problem.

  I have prepared two solutions to the problem:

• Use COLUMN to solve this problem

result_column = 
VAR _1 =
    CALCULATE (
        MAX ( 'Table'[Time at Build Place] ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) - 1 )
    )
VAR _2 = 'Table'[Time at Build Place] - _1
RETURN
    IF ( 'Table'[Index] = 1, BLANK (), _2 )

• Use MEASURE to solve this problem

result_measure =
VAR _1 =
    CALCULATE (
        MAX ( 'Table'[Time at Build Place] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Index]
                = SELECTEDVALUE ( 'Table'[Index] ) - 1
        )
    )
VAR _2 =
    CALCULATE (
        SUM ( 'Table'[Time at Build Place] ),
        FILTER (
            'Table',
            'Table'[Time at Build Place] = SELECTEDVALUE ( 'Table'[Time at Build Place] )
        )
    ) - _1
RETURN
    IF ( SUM ( 'Table'[Index] ) = 1, BLANK (), _2 )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Thank you for your questions and support! If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}