Power Query Erlang formula (not measure) request

[greegan]

= 1 / (1 + (1 - u / m) * EXP(GAMMALN(m + 1) - m * LN(u) + u) * POISSON(m - 1, u, TRUE))

Was given as a great answer to an Erlang calculation in this thread ...

Summation Part of Erlang C Formula

I would like to use this in Power Query.
I'm using Office 365 and I am currently working on a tool for my work to calculate Erlang C.

Eric W's answer was great, but I'm hoping it or the formula (preferably the above because I need more than 170 calculated) above can be used in a Custom Column formula. I'm not familiar enough with Measures to use one in place of adding a formula.

I understand M language now has POISSON added to Power Query and PBI.

for shg, I suppose I'm not understanding where the "u", "m" or "LN" would be positioned in my PQ steps?

Any help is appreciated.

-- g

 

[greegan]

This has somewhat been resolved as I have decided to use a LAMBDA function instead. I will post it here when I'm done figuring out how to use LAMBDA in excel, which then will allow me to query the results.

 

[Peter_SSs]

I have decided to use a LAMBDA function instead. I will post it here when I'm done

When you have done that then it is perfectly fine to mark that new post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[Peter_SSs]

I repeat ..

.. please do not mark a post that doesn't contain a solution.