Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Ideas for correlation analysis

I have invoicing data for two years:

factor - mm - yyyy - value

- value indicates the % share of annual invoicing by MO

 

I have made transformation so that I know if:

- factor has data for more than one time series (years)

- for how many months factor has value <> 0

 

I would like to see if there is correlation between years (values) for those factor which have data for both years. 

 

 

2 REPLIES 2
SriKandimalla
Helper I
Helper I

Hello @Anonymous ,

 

Can you specify the columns or features you want to see the correlation? 

Also, review the correlation coefficient quick measure in the following link

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#correlationCoefficient

 

 

 

Anonymous
Not applicable

I want to see if values between two years of data "correlate" and is it possible to produce one new value which I can use as a deviation value for next year budget value to be divided into months.

Eg.

Factor a has data for both years but all invoicing happens once a year -> budget is divided equally to each month

Factor b has data for both years and invoicing happens every month but there is high variation between months -> what kind of value is the best for dividing budget for months

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.