Forum Discussion
Solved
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 da...
I'm not sure what you're doing wrong but it works fine for me.
Do you have relationships between the two tables complicating things?
jereaallikko , A new column in table one using concatenateX
concatenateX( filter(Table2, Table1[ID] = table2[ID] && Table1[product] = table2[product]), table2[product code])
Hi amitchandak,
It didn't work. After a brief investigation, this measure works only if Table1[ID] = Table2[ID]. This should somehow be modified to link between "Product" columns. To Table1 a column or DAX like : Table2[Product] "contains" Table1[Product], then Table2[Product Code].
