Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
helpa
Frequent Visitor

Erlang-A (Abandon %) in PowerBI

I have seen a few posts on Erlang-C but none for Erlang-A have jumped out at me, if there is an ongoing post on this topic I'd appreciate a link to that please.

 

Hi, 

 

I have been working on shamelessly copying the Erlang Calculator from https://www.callcentrehelper.com into PowerBI thanks to the working example article erlang-c-formula-example 

However, there is the abandon rate column which isn't covered in the worked example as it is from Erlang-A. callcentrehelper don't have a worked example for Erlang-A, they only have the formula that's used - and that without any variable definitions. a-beginners-guide-to-the-erlang-a-formula 

 

helpa_0-1740150102670.png

I've searched and found an article from Calabrio which, whilst not exact, does show some similarities to the formula. Especially for A(x,y) and rho. 

 

helpa_1-1740150271933.png


Unfortunately, substituting this into the callcentrehelper formula fails to match what is showing on their calculator results. 

 

My question then, has anyone had experience creating an Erlang calculator with abandon % in PowerBI, and which formula and variables were used? 

 

I have managed to get exact matches for all of the Erlang-C output, just need the abandon % column.

 

Thank you

 

1 REPLY 1
rajendraongole1
Super User
Super User

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.