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...
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 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.