cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kk1791 Frequent Visitor
Frequent Visitor

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

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.date filter.PNG

 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

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

Hi @kk1791,

 

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

 

relative date slicer.PNG

 

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.

output.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kk1791 Frequent Visitor
Frequent Visitor

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

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.

 

 

date error.PNGSecond 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!

Community Support Team
Community Support Team

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

Hi @kk1791,

 

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

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