Dear All,
I need to estimate the number of Agents in the Call Center, so I am using Erlang C and following this article: https://www.callcentrehelper.com/erlang-c-formula-example-121281.htm as suggested in this forum in 2019. In the article: Erlang C = X/Y+X in which Y need a “for” loop to calculate (step 11 in the article). Besides, to meet wanted service level, I have to use a “while” loop (step 14 in the article). So, please advise me how to do these steps in Power BI or another solution to solve Erlang C.
Can you share your solution? It might be of interest to others.
BTW I do have a Power Query solution but that seems to have the same limitation as the article mentioned for a high number of agents, above 170 Factorial.
Also, as I am unfamiliar with this topic, I’m unsure what it needs to return - only 20 or … ?
Hi Melissa,
I am sorry for my late reply. In my case, due to Power BI’s limitations, I did the Erlang C algorithm in python and then imported the results into Power BI as the reference tables.
