Forum Discussion

QueenTink's avatar
QueenTink
Frequent Visitor
5 years ago

CONCATONATEX combining fields from two tables.

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

4 Replies

    • QueenTink's avatar
      QueenTink
      Frequent Visitor
      5 years ago

      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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.