Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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...
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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |