Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |