Forum Discussion

Data_Struggles_'s avatar
Data_Struggles_
Frequent Visitor
3 years ago
Solved

Queuing Theory Model implementation in PowerBI

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 ...
  • lbendlin's avatar
    lbendlin
    3 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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.