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