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"
Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

Hello lbendlin 

 

that DAX is superb, thank you.

I dont know if there is a sumx offset at line 6 (maybe) as a "bridge" before sumx the whole result as in Line 8 (thought it can be done directly by using earlier indexing).

I need to work again on my DAX understanding as a beginner.

 

Again, thank you and really appreciate for the 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