Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi All,
I have a data set with jobs booking. I want to create a report based on only the jobs that have a date range of the current day until the end of the month so today would be
25/10/2018 - 31/10/2018
then tomorrow would be
26/10/2018 - 31/10/2018 and so on
How can't seem to do it with relative date filters and not sure how else to go about it.
Any ideas?
Thanks
Solved! Go to Solution.
I would use 2 date filters on the report.
Set them as relative filtering.
Set the first one for current month.
set the second one for the next 31 days. Remenber to tjek the "include today" field.
They should offset each other, så you get your wanted result. 🙂
I would use 2 date filters on the report.
Set them as relative filtering.
Set the first one for current month.
set the second one for the next 31 days. Remenber to tjek the "include today" field.
They should offset each other, så you get your wanted result. 🙂
Awesome, I didnt realise you could use more than one of the same filters.
This works perfectly!
Appreciated ![]()
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |