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 ...
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

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity 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