Forum Discussion

joshuacisneros's avatar
joshuacisneros
Regular Visitor
7 years ago
Solved

Comparing values of the same column

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 <3

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.

 

4 Replies

  • Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

    • joshuacisneros's avatar
      joshuacisneros
      Regular Visitor

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

    • AnkitBI's avatar
      AnkitBI
      Icon for Solution Sage rankSolution Sage

      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