Issue on Power Pivot/Query Automatically Merge Duplicate Data

[tksnota]

Hi,

Is there a way to address the above issue because the sum of the pivot table and the original sheet is always different?

//NT

 

[alansidman]

Post a sample of your data using XL2BB and a mocked up solution.

 

[tksnota]

sorry i don't know what is xl2bb and how to use it? can i just show the before and after data via screenshots or there is another option?

 

[tksnota]

Table 1 is the original data showing less average and less count compared to Table 2 of power pivot. it is the other way around meaning the power pivot is duplicating the data

 

[RoryA]

I'm afraid that's all pretty meaningless out of context. Your top data set is clearly filtered on at least one column but we can't see how the pivot table is set up or filtered, or what may be going on in your data model. Any chance you can post the file to a site like onedrive so that we can have a look?

 

[tksnota]

this screenshot showed the data that power pivot made numerous duplicates of the original date e.g. -40986.67

what do you think i'm doing wrong? btw the other link table in the power pivots are ok so they matched

 

[RoryA]

That duplication wasn't in either of the images you posted before. Again, without context, I can't say why you are seeing that. It usually means something is wrong with your model - either an incorrect measure, or incorrect relationships most commonly.

 

[tksnota]

can i access the xl2bb because i'm using a company laptop and it is prohibiting me to install any other exe files?

 

[RoryA]

XL2BB is unlikely to help in this situation as I need to see the actual pivot table and data model. Can you upload it to onedrive or a similar site?

 

[tksnota]

sure. i had google drive that i can use. please advise what i need to do so you can query my works...