Forum Discussion
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 example, the 1st record would stand on its own. Then the other subsequent records would have values of: "570, 310", "711, 730", and then "711,730" respectively. In the main power bi report, I can then display that column in a table for each employee. Hope this makes sense. I am sure I need to do something in the query itself. Thanks for any help
3 Replies
- parry2k
Super User
guyatisk 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
guyatiskHi 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