Relative date filtering

Question

I have a list of elements with a planned end date and I would like to do a relative filtering of the date in the visualization to only show those whose end date is greater than or equal to 6 months ago and those that have a date in the future, I am using a slicer with relative date style, but it only allows me to see those of the last x months, those of the next months or those of the current month, I do not see an option that allows me to do what I want to show from a relative date in forward including those of the future, do you have any idea how I could do it?

Thanks in advance!

some_bih · Answer

Hi&nbsp;monicajsv&nbsp;check link for examplehttps://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range&nbsp;Hope this help, kudos apprreciated.

some_bih · Answer

Hi&nbsp;monicajsv&nbsp;possible solution as followingIf you need measure then it could be like:Measure test=CALCULATE (SUM(Yourtable[somecolumn]),DATESINPERIOD ( &nbsp; &nbsp; &nbsp; &nbsp; 'Date'[Date], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- Your Date key column&nbsp; &nbsp; &nbsp; &nbsp; TODAY(), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- Today&nbsp; &nbsp; &nbsp; &nbsp; -6, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- the set needs to contain 6&nbsp; &nbsp; &nbsp; &nbsp; MONTH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- months&nbsp; &nbsp; ))&nbsp;DAX function DATESINPERIODhttps://learn.microsoft.com/en-us/dax/datesinperiod-function-dax?WT.mc_id=DP-MVP-4025372&nbsp;Did I answer your question? Kudos appreciated / accept solution!&nbsp;

monicajsv · Answer

Thanks for your reply, but this options don't resolve what I would like to filter

some_bih · Answer

Hi monicajsv&nbsp;so you want to control some end of months in past / future? If yes, what is reference date, previous month or...share example with output

monicajsv · Answer

What I would like to have is a behaviour like the "After" Slicer style, but with tthe "after" date always showing today minus 6 months automatically

Forum Discussion

Relative date filtering

10 Replies

Related content

Find Most Recent Date Relative to another Date Column in Power Query

Date filter - Relative Dates

Relative date filters resetting

Relative date filter returns wrong date range

Relative Date Filter suddenly stopped working