Чтобы передать динамическую дату "Сегодня":
Проведя час, я нашел решение [Name="events_intraday_
"&datetime&"
"и объявил datetime = DateTime.ToText(DateTime.LocalNow(), "yyyyMMdd")
let
datetime = DateTime.ToText(DateTime.LocalNow(), "yyyyMMdd"),
Source = GoogleBigQuery.Database(null),
#"apple-5a221" = Source{[Name="apple-5a221"]}[Data],
analytics_187358390_Schema = #"apple-5a221"{[Name="analytics_187358390",Kind="Schema"]}[Data],
events_intraday_20200129_Table = analytics_187358390_Schema{[Name="events_intraday_"&datetime&"",Kind="Table"]}[Data]
in
events_intraday_20200129_Table
Чтобы передать вчерашнюю динамическую дату:
datetime = Date.ToText (Date.AddDays (Date.From (DateTime.FixedLocalNow ()), - 1), «ггггММдд»)
let
datetime = Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1), "yyyyMMdd"),
Source = GoogleBigQuery.Database(null),
#"prutopia-5a221" = Source{[Name="apple-5a221"]}[Data],
analytics_187358390_Schema = #"apple-5a221"{[Name="analytics_187358390",Kind="Schema"]}[Data],
events_datetime_Table = analytics_187358390_Schema{[Name="events_"&datetime&"",Kind="Table"]}[Data]
in
events_datetime_Table
person
KARTHIKEYAN.A
schedule
29.01.2020