Forum Discussion

polman4's avatar
polman4
Helper I
4 years ago
Solved

Power Query - GA - Date (Yesterday)

Hello,   I have made a query with the google analytics connector that power bi desktop comes with. I'm using the following to filter the dates   #"Filtered Rows" = Table.SelectRows(#"Added Items"...
General Comment
  • amitchandak's avatar
    amitchandak
    4 years ago

    polman4 , for tomorrow it should be +1. Also convert it to date before adding days

     

    #"Filtered Rows" = Table.SelectRows(#"Added Items", each [Date] >= #date(2022, 01, 01) and [Date] <= Date.AddDays(DateTime.Date(DateTime.LocalNow()),1))

polman4's avatar
polman4
Helper I
4 years ago

Thank you amitchandak ! Worked great

 

If someone wants yesterday just "-1" instead of "1"