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.