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.
Hi all,
in the latest blog post from the September 2021 update, there was a visual by PAFnow.
It collects the data from a event-like table and calculated lead times based on a key.
Let's say I want to track the movement a shipment. Each shipment has lots of scanpoints and corresponding scantypes:
ShipmentId | ScanType | Timestamp |
124 | LeaveWarehouse | 2021-09-23 09:00:00 |
124 | DepotEntry | 2021-09-23 10:00:00 |
124 | DepotSorted | 2021-09-23 12:00:00 |
124 | LoadOnTruck | 2021-09-24 06:00:00 |
124 | CustomerReceivedOK | 2021-09-24 12:00:00 |
124 | ReturnShipmentIssued | 2021-09-25 16:00:00 |
So with a process mining tool I would be able to calculated the time between each node...
However, let's say I want to model the lead times by myself. Are there any best practises? Could I DAX the leadtimes (each measure is the process-step) with the table structure as provided above or should I pivot the table on loading based on the shipment?
I would highly appreciate to receive some information of blog posts or videos on similar use cases.
Best regards,
Konstantin
Hi @rks ,
Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.
Best Regards,
Eyelyn Qin
Hi @v-eqin-msft ,
I do like your links and ideas. And I also got the idea for asking about this topic by watching the recent blog entry. The solution provided there is also pafNow, which seems to be quite a bit of useful software. However, I was also interested in researching ways to achieve a smiliar, lest less generic, approach by using DAX only and not rely on external tools.
Hi @rks ,
I may suggest you use DAX to create measures for TimeStamp/End-TimeStamp field in Process Mining visual.
Refer to:
https://pafnow.com/blog/process-mining-101-what-is-process-mining/
https://community.powerbi.com/t5/Data-Stories-Gallery/Process-Mining-in-Power-BI-PAFnow/m-p/1259223
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |