ADD an Interger column

[MichaelJackpbi]

Hi friends,
I have a time dimension contains OrderDate( date type),year, month,week, day. Now i need to add a new column naming Date_ID(interger) in power bi to insert the number of row in my table

I.e. I set the Date_ID for my firstdate in time dimension as 1

the next day will be 2

...

sumary, it will allocate the interger one by one for my new column from the first date to lastdate!

best regards,

J. 

[BhaveshPatel · Accepted solution]

GO TO QUERY EDITOR AND UNDER THE ADD COLUMN TAB, SELECT ADD INDEX COLUMN FROM 1.