Comparing values of the same column

[joshuacisneros]

Hi everybody, my english is so bad, but I need your help to create a matrix visual like the photo attached.
1)I want to compare the prices from a list that I have. (point 1) Dividing the price of each product row for a column transposed of the same list of products (point 2), as result a matrix with values in percent (point 3) for the purpose of concluding if products A,B,C are more expensive or cheaper than the rest of products. (point 4).

I hope you can understand me ❤️

P.S: I think that it's a linear algebra problem because de column is (n rows x 1 column) multiplying the column transposed ( 1 row x n columns) as result a matrix (n rows x n columns). Example: 4 products generate 16 possible results.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[AnkitBI]

@Ashish_Mathur @joshuacisneros

I used somewhat different approach using CrossJoin. But your solution is better as mine can get bulky in case of large amount of data.

Just adding for reference PBI

[joshuacisneros]

OMG!!!!, Thanks a lot, your solution it's perfect! That was exactly what I was looking for.

[Ashish_Mathur]

You are welcome.