Forum Discussion
Limiting the data returned in a PBI query
It is best to have your date and time as separate fields, so I would separate that, then make sure the date field is set to the data type of date. Once that is done, you can click on that field and go into your filter options:
You can set it to be after 12/31/2019 or whatever works best for you (perhaps you have to keep the last 4 full years of data and data from this year so you could do something like this:
This is how I'm currently filtering the data by the date but I'm not sure if this is the most effective way?
Super UserIt is best to have your date and time as separate fields, so I would separate that, then make sure the date field is set to the data type of date. Once that is done, you can click on that field and go into your filter options:
You can set it to be after 12/31/2019 or whatever works best for you (perhaps you have to keep the last 4 full years of data and data from this year so you could do something like this: