Forum Discussion

Kehaar's avatar
Kehaar
New Member
2 years ago
Solved

Exponential Regression

Hello,

Is there a way in Power BI, perhaps with a DAX function, to take a table of x- and y-values and calculate an exponential regression equation through the data?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Kehaar 

    You can use "POWER" Dax function. Like this

    y = [Column1] * POWER([Column2], 3)

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • Kehaar's avatar
      Kehaar
      New Member

      Hello,

      I do not believe the thread you referenced helps to create functions of the form y = a*b^x, that is to say, exponential functions. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Kehaar 

    You can use "POWER" Dax function. Like this

    y = [Column1] * POWER([Column2], 3)

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.