Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Modeling advise for processing mining

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:

124LeaveWarehouse2021-09-23 09:00:00
124DepotEntry2021-09-23 10:00:00
124DepotSorted2021-09-23 12:00:00
124LoadOnTruck2021-09-24 06:00:00
124CustomerReceivedOK2021-09-24 12:00:00
124ReturnShipmentIssued2021-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,


Community Support
Community Support

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 @Eyelyn9 ,


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.

Community Support
Community Support

Hi @rks ,


I may suggest you use DAX to create measures for TimeStamp/End-TimeStamp field in Process Mining visual.


Refer to:


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.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.