Forum Discussion
kberg87430
8 years agoNew Member
Microsoft Project Online - PowerBI Desktop - Resource Assignment Report
I am trying to create a Report showing Projects, Tasks, and assigned resources for all tasks that are <100% complete. I add: ProjectManagerName <Custom Field> ProjectName TaskName TaskPerece...
wgjunsay
7 years agoAdvocate I
Hello kberg87430 if this is still an outstanding inquiry, here is how I solved it:
Assuming you will be pulling the "ResouceName" field from "Resources" table, You'll have to bring "Assignments" table to the report. The "Assignments" table links the "Resources" and "Tasks" table together through the fields "ResourceId" and "TaskId".
If you think this comment answered your question please set this as the solution and give a kudos. Thanks !
- kberg874307 years agoNew Member
That worked! Thank you so much