table LocalDateTable_3fa9633b-ab47-4d55-9058-c09d735d6003 isHidden showAsVariationsOnly lineageTag: 84e1070d-5f1a-493e-ad4a-60b5f823c768 column Date dataType: dateTime isHidden lineageTag: 15539f7d-bc4f-40ea-aaca-a258ff53722a dataCategory: PaddedDateTableDates summarizeBy: none isNameInferred sourceColumn: [Date] annotation SummarizationSetBy = User column 年 = YEAR([Date]) dataType: int64 isHidden lineageTag: 0d57458b-5778-4447-942c-1f0257c947e9 dataCategory: Years summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = Year column MonthNo = MONTH([Date]) dataType: int64 isHidden lineageTag: a2d6cfc5-a703-4dc6-8b4a-0a5beaf00a1b dataCategory: MonthOfYear summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = MonthNumber column 月份 = FORMAT([Date], "MMMM") dataType: string isHidden lineageTag: 09ff6b4a-4d25-4f79-acb8-8c8ff574f6a1 dataCategory: Months summarizeBy: none sortByColumn: MonthNo annotation SummarizationSetBy = User annotation TemplateId = Month column QuarterNo = INT(([MonthNo] + 2) / 3) dataType: int64 isHidden lineageTag: 00c4ae0d-65d8-437e-ba6a-3dbd07f167db dataCategory: QuarterOfYear summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = QuarterNumber column 季度 = "季度 " & [QuarterNo] dataType: string isHidden lineageTag: cca24022-e88f-4995-a34f-0ffa01cddb63 dataCategory: Quarters summarizeBy: none sortByColumn: QuarterNo annotation SummarizationSetBy = User annotation TemplateId = Quarter column 日 = DAY([Date]) dataType: int64 isHidden lineageTag: 33727464-8b9d-44a2-9273-3b8bce7f5296 dataCategory: DayOfMonth summarizeBy: none annotation SummarizationSetBy = User annotation TemplateId = Day hierarchy 日期层次结构 lineageTag: 8a09d636-e9f7-4059-832a-ffa48a3be693 level 年 lineageTag: 02a6fbf9-60c3-4afb-b466-be86affb280b column: 年 level 季度 lineageTag: b4797ef9-00e9-45c5-aa64-fcda237a399f column: 季度 level 月份 lineageTag: 38a88a73-5909-4e74-9ec6-f8a8b8558075 column: 月份 level 日 lineageTag: b2948c8e-e71c-4b1f-9fad-2e44f627a662 column: 日 annotation TemplateId = DateHierarchy partition LocalDateTable_3fa9633b-ab47-4d55-9058-c09d735d6003 = calculated mode: import source = Calendar(Date(Year(MIN('dm_td_user_permission_detail'[etl_update_dt])), 1, 1), Date(Year(MAX('dm_td_user_permission_detail'[etl_update_dt])), 12, 31)) annotation __PBI_LocalDateTable = true