Forum Discussion
Replicate from Excel / Time Differences and Average
- 7 years ago
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
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
- bcampbell7 years agoHelper I
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