37 lines
1.0 KiB
Plaintext
37 lines
1.0 KiB
Plaintext
table '.Календарь'
|
||
|
||
measure 'Курс TODAY-1, usd2' = CALCULATE(MAX('Себестоимость'[Курс usd2]), '.Календарь'[Дата] = TODAY() - 1)
|
||
|
||
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
||
|
||
column Дата
|
||
formatString: m/d/yyyy
|
||
summarizeBy: none
|
||
sourceColumn: [Date]
|
||
|
||
variation Изменение
|
||
isDefault
|
||
relationship: be16665c-6e35-421d-a938-614c9b5b4485
|
||
defaultHierarchy: LocalDateTable_e0374236-67f4-4331-b4f5-c977a3082bab.'Иерархия дат'
|
||
|
||
annotation SummarizationSetBy = Automatic
|
||
|
||
annotation PBI_FormatHint = {"isDateTimeCustom":true}
|
||
|
||
annotation UnderlyingDateTimeDataType = Date
|
||
|
||
column 'Год неделя' = YEAR('.Календарь'[Дата]) & "-" & FORMAT(WEEKNUM('.Календарь'[Дата], 2), "00")
|
||
summarizeBy: none
|
||
|
||
annotation SummarizationSetBy = Automatic
|
||
|
||
partition '.Календарь' = calculated
|
||
mode: import
|
||
source = ```
|
||
CALENDAR(DATE(2018,01,01), DATE(2028,01,01))
|
||
|
||
```
|
||
|
||
annotation PBI_Id = 96f54ceb7af44a4682e4399eeac84d37
|
||
|