Log In
Register
Home
Adding custom date column that increase by one day each row
Toussaint Ops
Active Member
Members
Forum Posts: 3
Member Since:
July 27, 2022
July 27, 2022
Offline1
July 27, 2022 - 6:41 am
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?
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1939
Member Since:
November 8, 2013
November 8, 2013
Offline2
July 27, 2022 - 3:35 pm
Hi,
Attached is an example, change the date as needed.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Wei Kwok Tey
Partha Pratim Nandy
Inge Rousseau
Forum Stats:
Groups: 3
Forums: 25
Topics: 7087
Posts: 31061
Member Stats:
Guest Posters: 49
Members: 34503
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —