Date Filter : Today's date + 2week and -2 week

[Anonymous]

Hello,

I would like to create a date filter which automatically changes todays date everyday and include data for +2 weeks and -2 weeks from todays date.

[v-piga-msft]

Hi @Anonymous,

As I know, we could create the relative date slicer like below.

In addition, if you have a calendar table, you could create the measure like below.

Measure = DATEADD('Table'[Date],-14,DAY)
Measure2 = DATEADD('Table'[Date],14,DAY)

Here is the output.

Best  Regards,

Cherry

[Anonymous]

Hello Cherry,

Thank you for your reply. But I have few doubts , regarding the date slicer using relative date filter. I am able to create that for two different date range, but once I do that I am not able to view any of my data in the visualization.

Second doubt,how did you create the table using the measure? I created a table with calendar date in one column and added your measure formula, but it ended up ina error message. I have attached the screenshot of it.

Let me know if you know the solution. Tnx!

[v-piga-msft]

Hi @Anonymous,

Sorry for the delay! 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry