CONCATONATEX combining fields from two tables.

[QueenTink]

Hello!

I am needing to combine two fields, each from different tables in my dataset. Example of the data is

Table1

productkey  productseries

12345             XYZ23

Table2

productkey productcode

12345           001-002-003

What I need is a column in Table1 with productseries &"-"& productcode (XYZ23-001-002-003)

I've tried a variety of different functions, but I'm not having any success. My latest attempt is below.

NewField= CONCATENATEX(Table1,CROSSFILTER(Table1[productkey],Table2[productkey],Both),Table1[productseries] &"-"& Table2[productcode])

Thank you

[m3tr01d]

@QueenTink Do you have a relationship between your two tables?
Is it Many to one?

[Greg_Deckler]

@QueenTink How about:

Column = [productseries] & "-" & RELATED('Table2'[productcode])

[QueenTink]

@Greg_Deckler I get an error saying it cannot find name. The only fields that seem to be available for this are other calculated fields in the table.

[Greg_Deckler]

@QueenTink Are you trying to create a column or a measure? The post said column. If you need a measure it will be like:

Column = MAX([productseries]) & "-" & MAX('Table2'[productcode])

This assumes an appropriate relationship between the tables.