Gamma Distribution

[Gernan]

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

[Greg_Deckler]

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.

[Gernan]

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

[v-yuezhe-msft]

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

[Gernan]

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