Penatibus interdum ac vehicula id semper parturient mauris, placerat at aliquet per praesent porta nulla nunc, ad imperdiet sed diam donec torquent. Dui porta dictum nullam lobortis faucibus aliquam nostra posuere euismod facilisis, platea proin urna dapibus tincidunt adipiscing primis hac cursus auctor, placerat sociosqu hendrerit pulvinar taciti neque felis mauris donec. Purus viverra adipiscing dignissim metus suscipit nec neque per, cum quisque nullam dui fames arcu iaculis, sociis tempus turpis est aptent at cubilia. Cras lacus class eleifend posuere erat senectus facilisi eget magnis rutrum, nibh integer natoque mauris dapibus pulvinar molestie pretium semper ipsum justo, aenean at volutpat vestibulum cubilia curae ultrices bibendum litora. Ultrices neque mi bibendum hac vulputate magnis lacinia molestie feugiat purus sem orci odio, cursus risus integer nullam lobortis morbi hendrerit cras gravida ridiculus porta. Neque nullam platea rutrum class fusce ipsum volutpat, parturient soci
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN MESSAGE. | |
Di9YC1huoW3Uqia kKV77J4SNeisdoF w5NIxR7pSDA3Rw2 kQjjQ62s004r8te | |
nqgiNPrz8p3d9RT efp8VESB5hfTCKq 6Xr2MZHgg6xg8sl 2zf2hthidQHOle5 | |
FOOruKxx0OIPzH4 TM7q8J5YwPJ4Xel 83t7Nvs1DSPjCRe gl0hgY8DcInoHrP | |
iEjsfNKwnwbjNgW Ngpol220pejLyM1 BIB312BwlTVlNtt . | |
END MESSAGE. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DEFINE | |
MEASURE factmetrica[s] = | |
SUM ( factmetrica[Клики] ) | |
EVALUATE | |
VAR _t0 = | |
SUMMARIZE ( | |
factmetrica, | |
FactMetrica[Поисковая фраза (Директ)] | |
) | |
VAR _t1 = |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
┌──────────────────────────────────────────────────┐ | |
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+-+-+ │ | |
│ |S|o|m|e| |d|a|n|c|e| |t|o| |r|e|m|e|m|b|e|r| │ | |
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+-+-+ │ | |
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+ │ | |
│ |S|o|m|e| |d|a|n|c|e| |t|o| |f|o|r|g|e|t| │ | |
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+ │ | |
│ │ | |
└──────────────────────────────────────────────────┘ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// killerDateTableRu | |
// функция killerDateTableRu создает таблицу с датами. Дополняет ее различными полезными для Time Intelligence столбцами. | |
// В случае, если четвертый аргумент принимает Дни 1, то функция добавляет столбец с выходными. | |
// Оригинальная идея philbritton https://gist.github.com/philbritton/9677152 | |
// пример: killerDateTableRu(#date(2017, 2, 1), #date(2017, 2, 4), "RU-ru", 1) | |
// Описание полей результирующей таблицы: | |
// =================================================== | |
// Date - дата | |
// Year - год |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Проект переехал в репозиторий https://github.com/power-bi/KillerDateTableRu |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NYsxCoAgFECvIk461IXEu1QQLZ2gzYZmCQSj8gzv3ygd2h6P95zT7BROogyGreJNloUko0xVFyWz4iDxElWnCFUXMg+lJbJaQ2gh17/YXnv/AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), | |
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), | |
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Changed Type", "Товар", each Text.BeforeDelimiter([Column1], "("), type text), | |
#"Inserted Text Between Delimiters" = Table.AddColumn(#"Inserted Text Before Delimiter", "Количество", each Text.BetweenDelimiters([Column1], "(", "х"), type text), | |
#"Inserted Text Between Delimiters1" = Table.AddColumn(#"Inserted Text Between Delimiters", "Цена", each Text.BetweenDelimiters([Column1], "х", "-"), type text), | |
#"Inserted Text Between Delimiters2" = Table.AddColumn(#"Inserted Text Between Delimiters1", "Стоимость", each Text.BetweenDelimiters([Col |
NewerOlder