Trying to add a Date table to Power Query and then add an index column / unique ID

[Omar_204]

Hello,

I am trying to add my date table to power query so I can add an index column (unique ID).

Unfortunately, there is no option to 'Add as new query'.

Any help would be greatly appreciated.

Thank you.

[v-eqin-msft]

Hi @Omar_204 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Refer to

Add Index Column In Power BI Using Power Query Editor

Solved: Add calculated index column by DAX - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[SpartaBI · Accepted solution]

Hi @Omar_204,

You are looking at the wrong place- The data view of Power BI instead of the Power Query editor.

You are here:

Instead of here:

Showcase Report – Contoso By SpartaBI