Forum Discussion
Solved
ADD an Interger column
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.
GO TO QUERY EDITOR AND UNDER THE ADD COLUMN TAB, SELECT ADD INDEX COLUMN FROM 1.
1 Reply
GO TO QUERY EDITOR AND UNDER THE ADD COLUMN TAB, SELECT ADD INDEX COLUMN FROM 1.