Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |