Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
@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
OMG!!!!, Thanks a lot, your solution it's perfect! That was exactly what I was looking for.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |