Solved: How to summarize text values of a column?

alex_powerbi · ‎05-17-2018

Hi there,

I am looking for a way to summarize text values in a column. I am getting data from MS Project Server that looks like this:

[Resources] 1-* [Assignments] *-1 [Tasks]

So multiple resources can be assigned to one task.

In my report on the other end, I want to have a table that's like this:

Task1 | Bill, Joe | ...

Task2 | Rose | ...

In the moment I get this:

Task1 | Bill | ...

Task1 | Joe | ...

Task2 | Rose | ...

How can I group the results by task? I tried to create a custom column but couldn't find a solution with DAX etc. so far...

Thank you in advance for any help!!

parry2k · ‎05-17-2018

Add a measure like this

m = CONCATENATEX(table, Table[emp], ",")

Drop task and this new measure in a table visual and you will get the expected result.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post