Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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
Proud to be a PBI Community Champion
@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
Proud to be a PBI Community Champion
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |