Power BI Project Online Power Pack adding resources names to tasks

New Contributor

I am using the Power Bi Project Online Power Pack. I want to add the resource name to the Gantt 2.2.3 visual and a table visual I created. I understand that there is a many to one relationship between the assignments table and the task table and they could be related by Task ID.  I cannot find a way to do it without some customization to the tables, but I might just be missing something, since I am new to Power BI. I am basically trying to create a table similar to the MS Project Task Sheet view with the resource names.  


I tried a few things, but could not find anything that works, so I might just need a help with the the formula I am trying for the custom column I am creating on the Tasks table. 


I want to add Task resource names (from the assignments table) to a column in the tasks table.  I tried using concatenatex with a filter, but cannot find a syntax that will work.  I tried many different versions of the formula and could not get it to work. I also tried adding calculate, but that did not work either. Here is one of the formulas I tried.


TaskTeam = CONCATENATEX(Assignments, Assignments[Resource Name], ", "), FILTER(Tasks[Task ID] = Assignments[Task ID])






1 Reply
best response confirmed by makins83 (New Contributor)

I determined the proper syntax is: 

TaskTeam = CONCATENATEX(FILTER(Assignments, tasks[Task ID] = Assignments[Task ID]), Assignments[Resource Name], ", ")