Matrix Year vs Year

[GFire]

Hi,

From the attached dataset, create the image matrix. Please.

Dataset:

https://docs.google.com/spreadsheets/d/1UpU-BSpuBebzvAelfOPYFwBqZZWTv085/edit?usp=sharing&ouid=11160...

Output Matrix 

[Ashish_Mathur]

Hi,

Does 900 (at the intersection of 2017 and 2018) mean that the "Customers who gave us business worth 2000 in 2017, gave us business only work 900 in 2018?"?

[GFire]

Hello, and thank you for your interest. I just solved the problem. I've added the .pbxi file with the solution in the link above.

[gmsamborn]

Hi @GFire 

I would like to help but I'm a little unclear about your requirements.

Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 A .pbix file with sample data would be best.

[gmsamborn]

Hi @GFire 

Can you explain how you have Year on both rows and columns but there is only one Year in your table?

I'm not sure how you would be able to create your expected matrix with Year on both rows and columns.

The result would give you a diagonal line of values in your matrix.  I'm not sure how useful that would be.

[GFire · Accepted solution]

Hello, and thank you for your interest. I just solved the problem. In the link above, I've added the .pbxi file with the solution. There you can see how I solved your problem with the year columns.