Forum Discussion

SRobbo1990's avatar
SRobbo1990
Frequent Visitor
3 years ago

Concatenatex with summarize

Hi All,

 

I'm currently trying to concatenate a list of suppliers (supplier table) by an Trip ID (itinerary item table)  (as below);

So that it would show Trip Id 10000175 with the full list of suppliers concatenated

 

I've tried to use the following command;

 

CALCULATE ( 
    CONCATENATEX(
        SUMMARIZE('Itinerary Item', Supplier[Supplier Name]),
        Supplier[Supplier Name],
        ", ",
        [Supplier Name], ASC
    )
    )
 
Unfortunately this measure just throws back a full list of all the suppliers in the supplier table.
 
Any advice?
 
Thanks

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    SRobbo1990 

    CONCATENATE =
    VAR Tables =
    SELECTCOLUMNS ( F, "Comments", F[Comments] )
    RETURN
    CONCATENATEX ( Tables, [Comments], "," )

    SRobbo1990 If this post helps, then please consider Accept it as the solution and give Kudo to help the other members find it more quickly.  
  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    3 years ago

    SRobbo1990 , I don't know how your data model looks like, but you can try to use the same table: