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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors