Forum Discussion

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago
Solved

Need Help on Autocorrelation Calculation

Hello Power BI expert,   I need an advice on how to do autocorrelation calculation in Power BI. for now i am trying to replicate the result from excel tutorial. I read there are two ways of...
"Need Help"
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

As always you can approach the issue with different DAX functions but you will want to unlearn EARLIER and embrace the window functions. Makes the shifted reference so much easier.

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

hello lbendlin 

 

sorry in advance, i got another question, is it possible to put the measure (the correlation result) into a new column?

 

Thank you and appreciate for the help.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    You cannot create columns from measures. You would need to modify the code to create a calculated column instead

    • Irwan's avatar
      Irwan
      Icon for Super User rankSuper User
      2 years ago

      Hello lbendlin 

       

      alright then, thank you again for the help and support.