SOLVED

Power BI Project Online Power Pack adding resources names to tasks

%3CLINGO-SUB%20id%3D%22lingo-sub-1467581%22%20slang%3D%22en-US%22%3EPower%20BI%20Project%20Online%20Power%20Pack%20adding%20resources%20names%20to%20tasks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467581%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20Power%20Bi%20Project%20Online%20Power%20Pack.%20I%20want%20to%20add%20the%20resource%20name%20to%20the%20Gantt%202.2.3%20visual%20and%20a%20table%20visual%20I%20created.%26nbsp%3BI%20understand%20that%20there%20is%20a%20many%20to%20one%20relationship%20between%20the%20assignments%20table%20and%20the%20task%20table%20and%20they%20could%20be%20related%20by%20Task%20ID.%26nbsp%3B%20I%20cannot%20find%20a%20way%20to%20do%20it%20without%20some%20customization%20to%20the%20tables%2C%20but%20I%20might%20just%20be%20missing%20something%2C%20since%20I%20am%20new%20to%20Power%20BI.%20I%20am%20basically%20trying%20to%20create%20a%20table%20similar%20to%20the%20MS%20Project%20Task%20Sheet%20view%20with%20the%20resource%20names.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20a%20few%20things%2C%20but%20could%20not%20find%20anything%20that%20works%2C%20so%20I%20might%20just%20need%20a%20help%20with%20the%20the%20formula%20I%20am%20trying%20for%20the%20custom%20column%20I%20am%20creating%20on%20the%20Tasks%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20add%20Task%20resource%20names%20(from%20the%20assignments%20table)%20to%20a%20column%20in%20the%20tasks%20table.%26nbsp%3B%20I%20tried%20using%20concatenatex%20with%20a%20filter%2C%20but%20cannot%20find%20a%20syntax%20that%20will%20work.%26nbsp%3B%20I%20tried%20many%20different%20versions%20of%20the%20formula%20and%20could%20not%20get%20it%20to%20work.%20I%20also%20tried%20adding%20calculate%2C%20but%20that%20did%20not%20work%20either.%20Here%20is%20one%20of%20the%20formulas%20I%20tried.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETaskTeam%20%3D%20CONCATENATEX(Assignments%2C%20Assignments%5BResource%20Name%5D%2C%20%22%2C%20%22)%2C%20FILTER(Tasks%5BTask%20ID%5D%20%3D%20Assignments%5BTask%20ID%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1467581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBusiness%20Intelligence%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOnline%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1472677%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20Project%20Online%20Power%20Pack%20adding%20resources%20names%20to%20tasks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472677%22%20slang%3D%22en-US%22%3E%3CP%3EI%20determined%20the%20proper%20syntax%20is%3A%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3ETaskTeam%20%3D%26nbsp%3B%3C%2FSPAN%3ECONCATENATEX(%3CSPAN%3EFILTER(Assignments%2C%20tasks%5BTask%20ID%5D%20%3D%20Assignments%5BTask%20ID%5D)%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EAssignments%5BResource%20Name%5D%2C%26nbsp%3B%3C%2FSPAN%3E%22%2C%20%22)%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
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])

 

Thanks,

Mark

 

 

1 Reply
Highlighted
Best Response confirmed by makins83 (New Contributor)
Solution

I determined the proper syntax is: 

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