Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone...
There's a way to create Gamma Contribution function from excel in DAX formula?
I hope you can help for this function.
Thanks.
Best Regards,
Gernan
There is no GAMMA function in DAX. You should add this as an Idea.
You could create an Excel file with a formula like:
For cell A2
A1+.01
For cell B1
GAMMA(A1)
Seed A1 with 1 and then copy the formula's down the rows to whatever maximum you want. Import the table into Power BI and use as a lookup table for gamma.
Hi smoupre,
Thank you for response. However, I want is GAMMA.DIST() function from excel. there's any way to create in power bi or it can be done on Excel?
Thanks
Regards,
Gernan
Hi @Gernan,
Currently, we are not able to create GAMMA.DIST() function in Power BI. A idea about this issue has been submitted in this link, please vote it.
If you want to create cumulative distribution function or probability density function type reports ultimately, you can consider to create such reports in Excel, then pin reports to Power BI dashboard following the instructions in this article.
Thanks,
Lydia Zhang
Hi Everyone,
There's a way to create Gamma Distribution function from excel in DAX Formula?
I hope you can help about this function.
Thanks.
Best Regards,
Gernan
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |