Skip to content

Instantly share code, notes, and snippets.

@maxim-uvarov

maxim-uvarov/pqmetrica20200504.txt

Created May 4, 2020 06:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maxim-uvarov/43aa07f0d93b8a08288cc38b1290303d to your computer and use it in GitHub Desktop.
Save maxim-uvarov/43aa07f0d93b8a08288cc38b1290303d to your computer and use it in GitHub Desktop.
Download ZIP
PQYandexMetrica - дни без расходов (null) заменить на дни с 0 расходов
Raw
pqmetrica20200504.txt
let
Source = PQYM("21781912", "ym:ad:<currency>AdCost", "ym:ad:date", "2020-01-17", "yesterday", "AQAAAAAQy8J1AAPquhq4JeyqQE6ygfUNoMnGr8E", null, "9803578"),
DateNullCheck = if Source[Дата]{0} = null then #table({"Дата", "Стоимость кликов, RUB"}, {{Date.AddDays(Date.From(DateTime.LocalNow()), -1), 0}}) else Source
in
DateNullCheck
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment