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
Power BI
Trusted Members
Moderators
Power BI
Forum Posts: 433
Member Since:
January 31, 2022
January 31, 2022
Online2
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: Hans Hallebeek, Riny van Eekelen, Amin Khajeh
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Lawrence Miu
Jo Saies
Paul Pritchard
Monique Roussouw
Keith Aul
Richard Dunks
Manjula Mangalmurti
Thomas Quidort
Jamie Preece
Bob Smith
Forum Stats:
Groups: 3
Forums: 24
Topics: 6192
Posts: 27146
Member Stats:
Guest Posters: 49
Members: 31848
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —