DAX Measure to Check Tag From Different Table
Hi all, I am trying to solve a problem with relationships and column mapping from other table. I have two tables, both containing hundreds of rows of data. I have created a simple illustration data below. Table1 is considered as Main Data table, whereas Table2 as Product Code mapping Table: I would like to add Product Code column to Table 1. So basically, I am looking for a solution (DAX, Relationships, etc.) to check if Product in Table2 is included in Product of Table1. If it is true, then it should map to the correct Product Code. I have tried to play with relationships, but it does not map correctly. As a result, all "Bert" Products should have a code FEB, "WayX" Products should have a code DCA etc... A desired outcome example: Any suggestions? Best Regards, Jere
