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:
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.
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.