Forum

Adding custom date ...
 
Notifications
Clear all

Adding custom date column that increase by one day each row

2 Posts
2 Users
0 Reactions
169 Views
(@toussaintops)
Posts: 3
Active Member
Topic starter
 

Hi all,

 

I currently have a table in power query that looks like this:

 

Weekday, Store, Count, Date

 

and there is data beneath the headers that are populating it but the date is null,

 

I want to add a date column that starts at 06/01/2020 and increase incrementally down the rows.

 

How would I go about doing this?

 
Posted : 27/07/2022 4:41 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi,

Attached is an example, change the date as needed.

Screenshot-2022-07-27-083222.png

 
Posted : 28/07/2022 1:35 am
Share: