Dynamic Filter for Rolling Past, Present, and Future Date Based On Today's Date

[markefrody]

Hi,

I'm trying to filter the date field to include the following only:

1. Today's date, and

2. All past dates before today's date, and

3. +10 days (into the future) after today's date

So the basis of the dynamic update will be always based on today's date.

Note: I'm using Direct Query as storage mode.

Relative date filtering does not have the option to filter get the all the dates as per my criteria above. Appreciate if you can help me with my request.

Best regards,

Mark

[v-juanli-msft · Accepted solution]

Hi @markefrody 

Do you want the date filtered in a visual, slicer, or a calculation?

Based on my knowledge, there is no slicer to achieve this goal directly.

As a workaround, i create a measure, then add this measure in the visual level filter.

Measure = IF(MAX(Sheet5[date])<=TODAY()+10,1,0)

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[markefrody]

@v-juanli-msft 

Hi Maggie,

Thanks for the assistance. This works.

Best regards,

Mark

[OOC2019]

The answer in #2 works when the data is not summarized (e.g. in a table), but does not work on other visuals when the data is summarized. For example, when the data is in a bar chart, column chart, or card, it shows the total number of results (42). Is there a way to modify the measure so that it works when the data is summarized?