Forum Discussion

DR's avatar
DR
New Member
9 years ago

calculate difference between time stamps for unique ID

Grateful for help with the following issue.   I have the following table with unique job IDs (score origin) and want to compare the difference in time between when that job ID is in a different sta...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi DR,

 

Please try this workaround:

 

Create a new table.

Table_1 =
SELECTCOLUMNS (
    FILTER ( 'time difference', 'time difference'[metric] = "ONST" ),
    "score time", 'time difference'[score time],
    "score origin", 'time difference'[score origin]
)

In original table, add a calculated column which displays the time difference between "ACCP" and "ONST".

time diff =
DATEDIFF (
    'time difference'[score time],
    IF (
        'time difference'[metric] = "ACCP",
        LOOKUPVALUE (
            Table_1[score time],
            Table_1[score origin], 'time difference'[score origin]
        ),
        BLANK ()
    ),
    SECOND
)

Regards,
Yuliana Gu