Skip to main content

Power BI

New

Relative date

Vote (15) Share
Stephen Potter's profile image

Stephen Potter on 07 May 2018 23:12:42

Relative Date Filter additional options

I use the relative date feature in both the slicer and the filters section and it's great. I would suggest adding an option of greater than. You can do less than ("is in the last") but you can not do more than ("not in the last")

For example show dates greater than 30 days old relative to todays date.

Comments (3)
Stephen Potter's profile image Profile Picture

abe85954 d624-4867-9e6b-9de7b31f6e50 on 06 Jul 2020 00:11:08

RE: Relative date

I agree with this completely. I frequently need to filter "today". When you use the relative filter for "Is in the last" X months, you can uncheck the "include today". So typically, my workaround is to add a filter for "is in the last 100 months" and uncheck the "include today" option. But it would be much easier to just have an option to set "not in the last 1 day".

Stephen Potter's profile image Profile Picture

62abebf3 3002-4a27-ae5a-033563664ca0 on 06 Jul 2020 00:07:28

RE: Relative date

yeah, make this. Seems obvious.

Stephen Potter's profile image Profile Picture

de924463 7c64-46cc-a4af-cbddb1d60d75 on 05 Jul 2020 23:30:28

RE: Relative date

I also have been trying to get this feature added to relative date filters. It should be a really simple add "is not in the last", "is not in the next".