PowerPivot - Unique Identifier

Question

Hi, 

Every  month I need to generate a single pivot table using power pivot since I have multiple sheets. This is my first month creating a report so all my sheets have a unique identifier but what happens when I add to the raw sheet next month to add on to the pivot table. Won't I have two of the unique identifiers? What can I do to keep the formatting so I can use power pivot? m

Thanks,

Christine

Answer 1

Hi,

The unique identifier is still only one - Unique ID.  Upload your workbook to OneDrive and share the link of the question here.

Answer 2

Hi Ashish, 

Thanks for your reply. The data that includes the unique identifier is a monthly data. I would like to continue to add to this sheet on a monthly basis. So for example, 2 month data would look like this below: 

unique ID, month, column1, column2

123, Jan, c1data, c2data

456, Jan, c1data, c2data

123, Feb, c1data, c2data

456, Feb, c1data, c2data

Thanks,

Christine

Answer 3

Hi,

Why will there be 2 identifiers?  Won't the structure of the next month's files also be the same.