Forum Discussion

Gernan's avatar
Gernan
New Member
9 years ago

Gamma Distribution

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's avatar
Greg_Deckler
Community Champion
9 years ago

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's avatar
    Gernan
    New Member
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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