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 

 

here is the sample data. Basically that is a data came from the website that i mentioned (I am trying to recreate the result before applying it into real data).

Jan56
Feb58
Mar69
Apr50
May66
Jun68
Jul78
Aug73
Sept88
Oct90

 Here is the result that I wish to get in Power BI

 

However, if Power BI has no memory or concept of self-referencing, then it is impossible doing autocorrelation in Power BI?

 

Thank you and really appreciate for the help.

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

Ah, that's actually simple - basically a special case for a Pearson correlation within the column.  Let me play with that a bit.