Forum Discussion
Replicate from Excel / Time Differences and Average
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
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/339586
2 Replies
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/339586
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
