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 ea...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

  • joshuacisneros's avatar
    joshuacisneros
    Regular Visitor
    7 years ago

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      You are welcome.

  • AnkitBI's avatar
    AnkitBI
    Icon for Solution Sage rankSolution Sage
    7 years ago

    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