topic Re: Estimating Weibull Parameters in DAX Commands and Tips

Estimating Weibull Parameters

Anonymous — Thu, 21 Jul 2022 16:05:54 GMT

Hello!

I've been attempting to create a Weibull distribution in PBI in order to get the B50 and B10 life ratings for performance. In order to create it I've been attempting for a few days to create a dynamic index to do the calculations for it, but overall it seems PBI isn't optimized for computing something like this, and even if I solve the dynamic indexing problem I wouldn't be able to perform all the calculations, graph them, and get the estimated weibull parameters from that. Is there any better way to go about creating a weibull distribution to get life ratings? Would using an R script be the best possible solution? Or would the rest of the calculations be possible if the dynamic indexing problem can be solved?

I can provide more context to the situation if that would help to clarify anything.

Any advice or help is greatly appreciated

Re: Estimating Weibull Parameters

lbendlin — Sat, 23 Jul 2022 15:56:06 GMT

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Estimating Weibull Parameters

Anonymous — Tue, 26 Jul 2022 11:42:40 GMT

Hi Anonymous ,

This is the related document, you can view this content:

https://medium.com/@aakashtodakar/real-time-weibull-analysis-in-power-bi-a9391137d7c7

https://stat.ethz.ch/R-manual/R-devel/library/stats/html/Weibull.html

https://www.quora.com/How-do-I-plot-a-Weibull-plot-using-Power-Bi-Are-there-any-tutorials-available

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Estimating Weibull Parameters

Anonymous — Tue, 26 Jul 2022 12:39:39 GMT

Yes, these articles were very helpful! Over the past few days I've been using similar methods to get and develop my own weibull calculations in an R script which I found was the easiest way to get the parameters necessary. The library I used to do this was "EnvStats".

Thank you for the help!

For anyone attempting to do this in the future, the parameters from EnvStats weibull estimations (using the eweibull function) can be grabbed directly and saved in variables/vectors. So, any life ratings can be easily calculated.