Queuing Theory Model implementation in PowerBI

[Data_Struggles_]

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?

[lbendlin · Accepted solution]

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.