Log In
Register
Home
Dynamic Date range
Craig Easton
New Member
Members
Forum Posts: 1
Member Since:
August 12, 2022
August 12, 2022
Offline1
August 12, 2022 - 8:36 am
Hi everyone, first post so go easy on me...
I am trying to filter my power query report between 2 dates but these change each month so it needs to be dynamic. Essentially the date column needs to show all dates between the 25th of 2 months ago and the 24th of the current month. And as said this needs to update each month to adjust to the current month.... If anyone can help me it would be great. Thanks!
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Moderators
Moderators
Forum Posts: 1032
Member Since:
January 31, 2022
January 31, 2022
Offline2
August 12, 2022 - 2:42 pm
Hi Craig,
I guess the easiest would be to create two variables in Excel and connect to them with PQ. The end_date could be calculated with:
=DATE(YEAR(TODAY()),MONTH(TODAY()),24)
and the start date would then be derived from that with:
=EDATE(end_date,-2)+1
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Craige Thompson
Elmo Erasmus
Robbin Kappelhof
Drew Smith
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
Forum Stats:
Groups: 3
Forums: 25
Topics: 7073
Posts: 30998
Member Stats:
Guest Posters: 49
Members: 34471
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —