Forum Discussion
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...
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 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?
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 ?