Skip to content
Функция, возвращающая таблицу с доп полнями для Time Intelligence BI функций. Для Power Query. Переехала отсюда: https://gist.github.com/maxim-uvarov/d58cd21da4e486abc1408e4ae58f302d
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
KillerDateTableRu.pq
KillerDateTableRuDevFile.pbix
LICENSE
README.md
data-20180410T1145-structure-20180410T1145.csv

README.md

KillerDateTableRu

Функция, возвращающая таблицу с доп полнями для Time Intelligence BI функций. Для Power Query.

Список столбцов и примеры значений

Название столбца Пример данных
Date 01.01.2015
DayOfMonthNumber 1
DaySeqNumber 1
DaySeqNumberReverse -1431
DayOfWeekName четверг
DayOfWeekNumber 4
DayOfYearNumber 1
WeekCalendarSeqNumber 1
WeekCalendarSeqNumberReverse -204
WeekStart 29.12.2014
WeekEnd 04.01.2015
WeekSeqNumberReverse -204
WeekOfYearNumber 1
MonthAndYear Янв 2015
MonthName Январь
MonthSeqNumber 1
MonthSeqNumberReverse 48
MonthOfYearNumber 1
MonthStartDate 01.01.2015
QuarterAndYear Q1 2015
QuarterOfYear 1
Year 2015
YearMonthDateNumber 20150101
YearMonthNumber 201501
IsHolidayInRussia true
IsShortDayInRussia false
You can’t perform that action at this time.