Power Query - GA - Date (Yesterday)

[polman4]

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", each [Date] >= #date(2022, 01, 01) and [Date] <= #date(2022, 02, 27)),

Ι would like to change the date to dynamically be tomorrow. I tried this but it won't work: 

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

Any suggestion?

Thank you!

Grigoris

[polman4]

Thank you @amitchandak ! Worked great

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

[amitchandak · Accepted solution]

@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))