Replicate from Excel / Time Differences and Average

[bcampbell]

I am trying to replicate my excel item in a power bi 

My source table has

Column1   Column2             Column3 

1                 REPT         12/1/2018 9:00:00 AM

1                 DISP         12/1/2018 9:23:00 AM

2                 REPT         12/1/2018 9:250:00 AM

2                 DISP         12/1/2018 9:55:00 AM

2                 CMPLT      12/1/2018 1:30:00 PM

1                 CMPLT      12/1/2018 2:00:00 PM

I would like to show the duration time from  DISP to CMPLT

Additionally I have a Matrix Table as such and would like to bring in a column for duration for each record

Callid |         REPT        |       DISP          |       CMPLT     |

1              9:00:00 AM       9:23:00 AM          2:00:00 PM

2              9:25:00 AM       9:55:00 AM          1:30:00 PM

Thank You

[Greg_Deckler · Accepted solution]

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[bcampbell]

Thank You sir for the information,

I have read over the article a few times .. and I beleive i understand what you created with your data

I issue i am having though is how my source data is not the same as your example data

Column1   Column2             Column3 

1                 REPT         12/1/2018 9:00:00 AM

1                 DISP         12/1/2018 9:23:00 AM

2                 REPT         12/1/2018 9:250:00 AM

2                 DISP         12/1/2018 9:55:00 AM

2                 CMPLT      12/1/2018 1:30:00 PM

1                 CMPLT      12/1/2018 2:00:00 PM

How could i create the measure that references Column1 , Column2 and Column3   (  1, DISP , 12/1/2018 9:23:00 AM ) and then create a new column that provides the difference of  ( 1, CMPLT , 12/1/2018 2:00:00 PM )

Thanks