cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Duplicate values on the table

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.

 

1 ACCEPTED SOLUTION
Community Support
Community Support

@Sandratdas 

 

You may take a look at the posts below.

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

@Sandratdas 

 

You may take a look at the posts below.

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors