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

QueenTink How about:

Column = [productseries] & "-" & RELATED('Table2'[productcode])
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.