Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Aggregate Tables

Hi,

 

I have a table which looks like the below

 

Case ID     Description

123            Cough

123            Irritable Bowels

123            Exploding Leg

 

Instead I am wanting to have it

 

 

Case ID     Description

123           Cough, Irritable Bowels, Exploding Leg

 

What would be the best way to achieve this?

 

Thanks

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please create a measure as below

     

    DescriptionConcat = CONCATENATEX(VALUES(AggTest[Description]), AggTest[Description], ", ")

    Now use the CaseID and measure that was created in above step in the table visual... then output will be

     

    OutputInput

1 Reply

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous Please create a measure as below

     

    DescriptionConcat = CONCATENATEX(VALUES(AggTest[Description]), AggTest[Description], ", ")

    Now use the CaseID and measure that was created in above step in the table visual... then output will be

     

    OutputInput