table LocalDateTable_5fbef699-2187-4467-b846-76fb159e8318 isHidden showAsVariationsOnly lineageTag: 75a528d3-f4a3-4023-9def-0d3fa7408328 column Date dataType: dateTime isHidden lineageTag: 11d82cca-c1d1-4f84-977b-a3108950134d dataCategory: PaddedDateTableDates summarizeBy: none isNameInferred sourceColumn: [Date] annotation SummarizationSetBy = User column 年 = YEAR([Date]) dataType: int64 isHidden lineageTag: 590f5280-1b09-4414-8d4e-872f020253f1 dataCategory: Years summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = Year column MonthNo = MONTH([Date]) dataType: int64 isHidden lineageTag: 1e118bc5-5d33-4fb2-8931-f6fad36a9954 dataCategory: MonthOfYear summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = MonthNumber column 月份 = FORMAT([Date], "MMMM") dataType: string isHidden lineageTag: 4b808bb9-7fab-4da6-a541-736d330c76d1 dataCategory: Months summarizeBy: none sortByColumn: MonthNo annotation SummarizationSetBy = User annotation TemplateId = Month column QuarterNo = INT(([MonthNo] + 2) / 3) dataType: int64 isHidden lineageTag: ec97600d-030e-44f7-ac79-9146e8d8c2e0 dataCategory: QuarterOfYear summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = QuarterNumber column 季度 = "季度 " & [QuarterNo] dataType: string isHidden lineageTag: 663068fa-a2a9-4f26-a891-9766ab291233 dataCategory: Quarters summarizeBy: none sortByColumn: QuarterNo annotation SummarizationSetBy = User annotation TemplateId = Quarter column 日 = DAY([Date]) dataType: int64 isHidden lineageTag: eec144cc-ae12-4e59-b48a-fa9e24042845 dataCategory: DayOfMonth summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = Day hierarchy 日期层次结构 lineageTag: 5d773bb9-95de-4c92-9aa3-ce5e168daa4c level 年 lineageTag: 000cda6e-3a06-48d5-86f9-87fada8d1f34 column: 年 level 季度 lineageTag: eeec9921-4365-400f-8ddb-72a33cdd8cd0 column: 季度 level 月份 lineageTag: 03c1f980-e0ae-47f1-8563-139b2b695f68 column: 月份 level 日 lineageTag: 5aeadca4-766f-4ff7-ad94-fa57b3b93e5e column: 日 annotation TemplateId = DateHierarchy partition LocalDateTable_5fbef699-2187-4467-b846-76fb159e8318 = calculated mode: import source = Calendar(Date(Year(MIN('Dim_Calendar_Alt'[DATE])), 1, 1), Date(Year(MAX('Dim_Calendar_Alt'[DATE])), 12, 31)) annotation __PBI_LocalDateTable = true