PowerPivot auto-increment Primary Key

[jantonio]

Hello Everyone,

I'm running into some issues creating a primary key for relationship basis in PowerPivot.

I need a unique identifier such as auto-increment (1,2,3,4,5...etc) for every single record that is in my table.

There is a similar thread but my request is different: http://www.excelforum.com/excel-misc...ot-tables.html

I have attached a sample copy of my actual PowerPivot file. As general info there are constant duplicates in every row. Can someone please guide me how my DAX formula should be allocated to the Primary Key column?

Any assistance given would be greatly appreciated.

Antonio