Forum Discussion

Leslie1015's avatar
Leslie1015
Frequent Visitor
3 years ago
Solved

Get the Time Difference

Hello everyone,

 

Can someone help me create a calculated column to get the ouput below?

IDDateIndexOutput
A8/3/2023 7:45:051 
A8/3/2023 7:45:1520:00:10
A8/3/2023 7:45:1730:00:02
B8/3/2023 7:45:211 
B8/3/2023 7:45:2720:00:06
A8/3/2023 7:45:2740:00:10
A8/3/2023 7:46:0150:00:34
A8/3/2023 7:46:1560:00:14
C8/3/2023 7:46:311 
C8/3/2023 7:46:5020:00:19
C8/3/2023 7:47:2030:00:30
B8/3/2023 7:47:4030:02:13

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Leslie1015 ,

    Calculated column:

    Output 2 = 
VAR CurrentID = TableName[ID]
VAR CurrentIndex = TableName[Index]
VAR CurrentDate = TableName[Date]
VAR PreviousRow = 
    CALCULATE (
        MAX ( TableName[Date] ),
        ALLEXCEPT ( TableName, TableName[ID] ),
        TableName[Index] = CurrentIndex - 1
    )
RETURN
IF (
    CurrentIndex > 1,
    CurrentDate - PreviousRow,
    BLANK ()
)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

2 Replies