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
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 612
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: Srikanth Amudhan, Kumud Patel
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 184
Newest Members:
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
https://www.afabola.net/
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6540
Posts: 28628
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —