Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Concatenate multiple row values into one based on unique ID, from different tables

    Posted Jul 21, 2020 10:11 AM
    I have been working on a measure to try and concatenate multiple string values into one based on a unique ID. If the values were all in the same table, I would do the following:

    Column =
    CONCATENATEX(FILTER(SUMMARIZE(Table1,Table1[Case Number],Table1[Field Type]),[Case Number]=EARLIER(Table1[Case Number])),[Field Type],"-")

    5.png
    However I am trying to do this across tables. The unique value is in lets say TableA, and the values I am looking to concatenate are in TableB. How Can I do the same thing shown above, but with values pulled from a different table?

    ------------------------------
    Chase S
    ------------------------------


  • 2.  RE: Concatenate multiple row values into one based on unique ID, from different tables

    Posted Jul 22, 2020 02:57 AM
    When I have such a case, I would merge the two tables into one table. Then you can use your formula. I don't know of a way in the Query Editor to combine data from different tables. In DAX such a thing might be possible.

    ------------------------------
    Martijn Pepping
    Bleiswijk
    630684026
    ------------------------------



  • 3.  RE: Concatenate multiple row values into one based on unique ID, from different tables

    Posted Dec 17, 2022 10:03 AM
    I am new to PowerBI and trying to achieve what you describe here (simply concatenate within same table).   I am getting this error "The end of the input was reached" and can't understand why.   Can you help?

    AllTalent = CONCATENATEX(FILTER(SUMMARIZE(Table1,Table1[RCMINVNumber],Table1[TalentName]),[RCMINVNumber]= EARLIER(Table1[RCMINVNumber])),[TalentName]],"-")

    Note:  Every time I try to save this measure it adds another end ) to this statement.

    Any help is appreciated. 



    ------------------------------
    David Mulberry
    Owner
    ------------------------------