Forum Discussion
Helper VRunning 52 weeks - create filter for repport
Hi bilingual ,
So you want to filter the data for the last 52 weeks, right?
If you have a date column in your data source, then you can use a relative date slicer to filter:
Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs
There is a difference between Weeks and Weeks (Calendar), it can be found in the above document, which has an explanation.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SageIf I read it correctly you require to keep only last 52 weeks of data in your model, what is your source, is it the relational database? Please check incremental refresh:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
If you are unable to use incremental refresh, you can apply filter.
Please elaborate more if above doesn't solve.