Forum Discussion

mattramirez2020's avatar
mattramirez2020
Helper 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 ?

amitchandak's avatar
amitchandak
Super User
6 years ago

mattramirez2020 , In M or Dax You can create a combined column in both tables and join on them

new column

Key = [Product Type] & " " & [Product ID]