Forum Discussion

rjs2's avatar
rjs2
Resolver I
6 years ago

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...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi rjs2 

 

it is a Power QUery style and could be use only in Power Query (Advanced editor)

 Date.AddDays(Date.From(DateTime.LocalNow() as datetime),-60)

 

It is a SQL-style (PL/SQL in your case) and could be used only in data load step as a part of PL/SQL query statement to extract data from data source

TO_DATE ('14-12-2019 00:00:00', 'DD-MM-YYYY HH24:MI:SS')

 

It's pretty clear for me, if you are trying to use PowerQuery statement in PL/SQL query it won't work

 

rjs2's avatar
rjs2
Resolver I
6 years ago

I now understand what you are saying az38 

 

What would be the correct way to only extract dates that are 60 days old?

  • az38's avatar
    az38
    Community Champion
    6 years ago

    rjs2 

    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

     

    • rjs2's avatar
      rjs2
      Resolver I
      6 years ago

      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.

    • rjs2's avatar
      rjs2
      Resolver I
      6 years ago

      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.