topic Re: CONCATONATEX combining fields from two tables. in DAX Commands and Tips

CONCATONATEX combining fields from two tables.

QueenTink — Thu, 12 Aug 2021 15:10:13 GMT

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

Greg_Deckler — Thu, 12 Aug 2021 15:22:43 GMT

QueenTink How about:

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

QueenTink — Thu, 12 Aug 2021 15:42:38 GMT

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 — Thu, 12 Aug 2021 16:34:26 GMT

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.

m3tr01d — Sun, 15 Aug 2021 16:25:24 GMT

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