Forum Discussion
guyatisk
Helper II
Helper IICreating a column to combine related record values
This represents a table that is a child of another master table. The relation is EURID. What I want to do is to combine two or more records into a field to represent Cost Centers. In this ex...
parry2k
Super User
Super Userguyatisk very hard to understand what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
guyatiskHelper II
Helper IIHi Parry. I need to aggregate the data (or group) by Title and display the CostCenters as one value, delimited by commas. So in the example above, the resulting dataset would be (titles are abbreviated):
| Title | CostCenter |
| 395dfffe0 | 711 |
| 5b5efc65 | 570, 310 |
| c992fa93 | 711, 730 |
| dda0d4be | 711, 730 |