Forum Discussion

mattramirez2020's avatar
mattramirez2020
Icon for Helper II rankHelper II
6 years ago
Solved

Two key columns (one text and one number)

Hi, I am relatively new to Power BI. I have sales data with a product ID and a product type that I am trying to build a relationship to a product table. The product numbers repeat across the categori...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    mattramirez2020 .

     

    Check this code:

     

    However, if you have products on sales that is not on products table you have more works to do, like compare and add them to products table. Do you have this situation ?

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi mattramirez2020 ,

 

Check this file: Download PBIX 

 

I assigned a new id for a combination Product Type & Product ID using Power Query.

  • mattramirez2020's avatar
    mattramirez2020
    Icon for Helper II rankHelper II
    6 years ago

    camargos88 Thank you for helping out! What you did makes perfect sense but I just can't figure out how to do it. I was able to assign all the products a unique ID/key but I can't figure out how you map back sales to a new key/id that did not previously exist?

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      mattramirez2020 .

       

      Check this code:

       

      However, if you have products on sales that is not on products table you have more works to do, like compare and add them to products table. Do you have this situation ?