How can i create a date filter that looks back from today minus 365

[Anonymous]

I am trying to create a date filter so  that the  Gateway refresh should pull all data in the data model. In the report layer, the filter date should return current date minute 365 days rolling to display by default. How can  i go about creating a filter of this nature? any help is appreciated.

[lbendlin · Accepted solution]

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

First create a date table:

Date = CALENDAR("2021,1,1","2022,12,31")

Then use the below measure on the table:

FILTER = IF(MAX('Date'[Date])<=TODAY()&&MAX('Date'[Date])>=TODAY()-365,1,0)

Then create slicer like the below:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

When i create this calendar table do i need to join it to my model?

[v-luwang-msft]

Hi @Anonymous ,

Yes ,create relationship between your table and slicer table.

Best Regards

Lucien

[lbendlin · Accepted solution]