Hello,
Firstly, i am sorry but i wont be able to put my pbix file here as its for our internal company usage so i will trying my best to explain my problem.
I am trying to replicate a Excel formula which is calculating Correlation Coefficient for two time series.
First time series is a MTD performance of a fund and other is MTD performance of another fund.
I want to get the correlation coefficient for these two time series for just last 12 months. So for every month end, i need correlation coefficient for last 12 months.
I tried using the quick measure in PowerBI for correlation coefficient but its not working i think.
Can anybody please let me know how can i calculate it for just last 12 months?
Kuber
Hi @kuberkgupta
I just found an instruction how to create Correlation Coefficient by DAX, along with good visualization.
Please check this link
Because I can not see your data, so for better calculation, you may need to create a table with 3 column (Column 1: Months [from Jan to Dec], Column 2: MTD performance of 1st fund, Column 3: MTD of 2nd fund)
If you do not want to create additional table, so the visualization will change depend on your data model
Hope this help
2 Likes
Thank you very much @hunghahuy . I will try this method and would confirm this if i am successful.
Thanks for your response to @kuberkgupta’s inquiry @hunghahuy!
@kuberkgupta, please tag the response as “solution” once the method suggested successfully solved your issue.
Have a good day!
Hi @kuberkgupta, we’ve noticed that no response has been received from you since May 2nd. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @kuberkgupta, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.