Forum Discussion
Power Query with a Date.AddDays
I am trying to write a query when it will only pull dates 60 days older than today, so I dont have to change the query when I refresh it This is what I have I get the error below WHERE ""Ta...
I now understand what you are saying az38
What would be the correct way to only extract dates that are 60 days old?
the best option (from my point of view) is to filter it in SQL-query
the second option is to use filter "In Previous" 60 days in Power Query
and the third option is to use advanced filter in visual filters Pane in the Report mode
I would rather have my query only pull the data needed, instead of pulling everything then filtering. I am trying to be sensitive to our environment and make it less of a load on the database.
I dont see a way to filter for anything 60 days or older. there isnt a filter for not in the previous 60 days.
There has to be away to only pull and load data that is 60 days old based off a date field.