Queuing Theory Model implementation in PowerBI

Data_Struggles_ — Fri, 17 Feb 2023 23:26:43 GMT

Does anyone have experience with Queuing theory and might be able to point me in the right direction as to how to implement it in DAX tables/measures in PowerBI? We have a need for Headcount outputs based upon inputs of Arrival Rate, Service Rate, and Average Wait Time; we've used an Excel add-in for Erlang for a while, but find that at low-volume it is highly inaccurate. I've looked into Queuing Theory a bit(even used ChatGPT for some assistance lol) but hit dead ends. Is there anyone who has worked with queuing theory who can point me in the right direction?

Re: Queuing Theory Model implementation in PowerBI

lbendlin — Sat, 18 Feb 2023 14:02:54 GMT

When you try to implement this in Power Query or DAX you soon realize that neither support the concept of mutable variables, and neither have memory/state storage capacities. You will have to resort to Python or R scripts for anything but the most basic cases. I once worked on a scenario for a bakery (incoming orders through the day versus machine availability and order urgency) and while possible with List.Accumulate and some dirty tricks it was a nightmare to program.

topic Re: Queuing Theory Model implementation in PowerBI in DAX Commands and Tips

Queuing Theory Model implementation in PowerBI

Re: Queuing Theory Model implementation in PowerBI