Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a requirement in my project where I have to replicate the cumulative NORM.DIST() Function of Excel in my tabular project.
e.g:- NORM.DIST(90,81,72,TRUE) -- This gives the cumulative normal distribution of the variable X which here is 90.
Currently, there is no built-in function that gives us this value and the mathematical formula for this isn't straightforward as it uses ERF and integration which again isn't present to use in SSDT or Power BI desktop.
Can you please help me as to how can I implement this? Please note I am talking about CUMULATIVE NORMAL DISTRIBUTION FUNCTION and not the probablity mass function.
Is there a way we can invoke excel function from the SSDT and return the result from excel back to SSDT? Or any other approach?
Thanks
Milan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |