I am attempting to self teach and gain a basic understanding of Power Pivot. So far I know that it allows me to create joins, instead of using VLOOKUP, and because I have used a different product in the past, I am aware of the joins concept. That said, I am trying to find out a way to return only the unique values from one data set to another.

For example, data set 1: 8821 rows of data, each one unique. Data set 2, 2837 rows of data, each one unique, and each one contained in data set 1. I join the table on ID, then start to create a pivot. If I happen to have the ID variable from data set 1 in the values section, then it still returns all the values. I suppose in my ideal world, it would limit out the records that are not part of the join. (Just as if I used VLOOK UP, all of those IDS that did not exist in data set two would have turned into #N/A.)

Perhaps I am over thinking this and I need to remember to call on the ID variable from the other data set. But, is there no way to have only the unique ID show? Is there something in my set up or in my join?

PP Issue.JPG

I would also love a Power Pivot 101 resource, I have watched a few webinars, etc. If any one has a great suggestion.

Lastly, I see a lot of "go easy on me" type posts. Is this forum known for not going easy on people? Please go easy on me.

Thanks,

Kate