Duplicate values on the table

[Anonymous]

Hi everyone,

I am trying to create a reasource heatmap. I am pulling in data from the Project Web App. I have a task table that shows the hours worked on each task and project name. I tried to merge the resource table to associate it with the tasks. I have multiple resourceses assigned for some tasks. 

When I merge the two tables, I can see that the tasks have been duplicated. Even the tasks that have just one resource assigned it just keeps repreating itself. I can't figure out where I could be going wrong.

Kindly help!

Thank you in advance.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Merge-multiple-tables-using-DAX/m-p/372821#M169161
• https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604

[amitchandak]

You have to create a common resource and task table and use it. Please share more details to help further.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490