Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
GO TO QUERY EDITOR AND UNDER THE ADD COLUMN TAB, SELECT ADD INDEX COLUMN FROM 1.
GO TO QUERY EDITOR AND UNDER THE ADD COLUMN TAB, SELECT ADD INDEX COLUMN FROM 1.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |