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 working on a project to put together a report on dowtime to drive down to the production floor. I have attached some sample data. I would like to calculate the total time number of seconds between each Actual Time entry and totalize the number of occurances that are over 45 seconds but ignore anything that is shorter in duration. Each 45 second occurance would be considered a downtime event. I would then like to know the total elapsed time of downtime events. Can anyone put me on the right path?https://villarifoodgroup-my.sharepoint.com/:x:/g/personal/cory_j_villaribros_com/EZ2HcMxdW9RPsqtO4V-...
Solved! Go to Solution.
Try this: Assuming your records are already sorted (by Import DateTime).
Create a calculated column, to get previous Import DateTime:
Perhaps you want something like 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...
I can help get you strarted. You will need to add an index column to your data. You can do this either in the original data or as an added column when you import the data into Power BI.
You then use this index column to address the nth-1 and nth items and do your subtraction to get the elapsed time. Just be careful at index 0. You can't subrtact 1 for that one.
From there you do your filtering and grouping as you need.
no problem on the index, the time difference is where I am stuggling. I have found a ton of data on how to subtract the contents of one column from another and have been sucessful doing it however, I cant seem to figure out how to get the elapsed time from transaction to transaction with data in the same column, any thoughts
?
To go further in my explination. You would use the index+1 and index to point to values within your time column. Those are the value that you are subtracting to get the elapsed time. I think I think I have an example of this in DAX. It might help to explain it better.
Yes please an example would help greatly if you have one, appreciate the continued help!
Try this: Assuming your records are already sorted (by Import DateTime).
Create a calculated column, to get previous Import DateTime:
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |