Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
When i create this calendar table do i need to join it to my model?
Hi @Anonymous ,
Yes ,create relationship between your table and slicer table.
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |