Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Can someone tell me what I have done differently please?
I have the quick measure in power bi, correlation coefficient, category column A, measure x column B and measure y column C. This gave me 0.9882 (to 4 decimals)
In excel I have simple used =Correl() function for A & B columns and have got 0.968161112
date | A | B |
01/01/2017 | 0 | 0 |
01/02/2017 | 200 | 5 |
01/03/2017 | 300 | 10 |
01/04/2017 | 400 | 16 |
01/05/2017 | 300 | 11 |
01/06/2017 | 200 | 4 |
01/07/2017 | 500 | 26 |
01/08/2017 | 600 | 29 |
01/09/2017 | 200 | 4 |
01/10/2017 | 100 | 1 |
01/11/2017 | 300 | 9 |
01/12/2017 | 200 | 4 |
Solved! Go to Solution.
Please,
i think the problem is in your data
control them
you can also try again with the data you posted here and you will get the right result
Hi,
you only need to increase the number of decimals
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thank you for taking a look for me. I must be doing something wrong in Power bi, i've increased the decimals and got 0.988171688836408
Have I done something wrong here?
Please,
i think the problem is in your data
control them
you can also try again with the data you posted here and you will get the right result
I did, I found it, thank you. I had a different value in the dummy figures.
User | Count |
---|---|
76 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
46 | |
45 |