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.
Morning all,
I am new to Power BI and I am already converted to it!
I am working with a data set (below). The first column is a reference number, the second is the time that process started, then the next are time stamps along that process flow. Each column represents a different step in that flow. There can be multiple flows for each reference number as you can see below. Sometimes a step is also missed out
I am trying to show 1) The average time taken between columns 2&3 (however want to exclude some high value numbers that will throw the stats out. I then want to show an average time difference between each step in the process, again ignoring the high value items which will push the average up.
Finally I am looking to produce a bar graph of column B which will show hours across the day when they start, which will show the busiest hours.
Any help would be appreciated.
Thanks
hi, @SOTO
Given the data shown, what is the expected output? Also, can you post that data as text instead of a picture?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
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 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |