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

 

 

4 Replies

  • 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

  • Gernan's avatar
    Gernan
    New Member
    9 years ago

    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