createOrReplace

	/// Date dimension table containing one row per date. Used to filter and group transactions by time periods. Supports both Order Date (active relationship) and Ship Date (inactive relationship).
	table Dates
		lineageTag: be2bb4b3-84fb-465d-badd-21572ee5552e
		dataCategory: Time

		/// The full date value. This is the primary key of the Dates table and is used to join to the Transactions fact table via Order Date (active) and Ship Date (inactive).
		column Date
			dataType: dateTime
			isUnique
			formatString: yyyy-mm-dd
			lineageTag: 36374cb5-dcb3-495c-a2ea-85fd7290e644
			summarizeBy: none
			sourceColumn: Date

			annotation SummarizationSetBy = Automatic

			annotation UnderlyingDateTimeDataType = Date

			annotation PBI_FormatHint = {"isDateTimeCustom":true}

		/// Numeric sort key for month in YYYYMM format (e.g. 202301). Used to sort the Month column correctly in visuals.
		column 'Month Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: fa735011-f317-4cd0-922c-56d40b83ebe6
			summarizeBy: none
			sourceColumn: Month Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// The abbreviated month name (e.g. Jan, Feb). Sort by Month Key to ensure correct chronological order.
		column Month
			dataType: string
			lineageTag: 6957e349-d0d2-4ea0-8d7b-33d793657395
			summarizeBy: none
			sourceColumn: Month
			sortByColumn: 'Month Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for quarter (e.g. 1, 2, 3, 4). Used to sort the Quarter column correctly.
		column 'Quarter Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: b061cb3f-87f9-43e3-ba02-fee16282827e
			summarizeBy: none
			sourceColumn: Quarter Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// The quarter label (e.g. Q1, Q2, Q3, Q4).
		column Quarter
			dataType: string
			lineageTag: 5b396532-b5b1-4a11-8de1-0351de15a72d
			summarizeBy: none
			sourceColumn: Quarter
			sortByColumn: 'Quarter Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// The calendar year as a text value (e.g. 2023).
		column Year
			dataType: string
			lineageTag: a9456a9e-9d88-4614-bda6-adc268d94ecf
			summarizeBy: none
			sourceColumn: Year
			sortByColumn: 'Year Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for day of week (e.g. 1=Monday). Used to sort the Day Of Week column correctly.
		column 'Day Of Week Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 67093e55-6907-4cbe-b076-aefd90f7a32f
			summarizeBy: none
			sourceColumn: Day Of Week Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// The day of the week name (e.g. Monday, Tuesday). Sort by Day Of Week Key to ensure correct order.
		column 'Day Of Week'
			dataType: string
			lineageTag: d3b2648d-d4ce-4a3d-9891-05be4a915f9e
			summarizeBy: none
			sourceColumn: Day Of Week
			sortByColumn: 'Day Of Week Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for week number within the year. Used to sort the Week column correctly.
		column 'Week Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 437c8c0d-7765-4386-b012-f0f8ec1542b2
			summarizeBy: none
			sourceColumn: Week Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// The week label or week number within the year.
		column Week
			dataType: string
			lineageTag: eb8e5231-2608-442a-810f-1cfffdfd7f4b
			summarizeBy: none
			sourceColumn: Week
			sortByColumn: 'Week Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key combining year and week (e.g. 202301). Used to sort Year Week correctly.
		column 'Year Week Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: db0fbad2-f439-4988-b8d8-e197db5df7e0
			summarizeBy: none
			sourceColumn: Year Week Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Combined year and week label (e.g. 2023 W01). Sort by Year Week Key to ensure correct chronological order.
		column 'Year Week'
			dataType: string
			lineageTag: 517f86cf-6efc-47a5-84b5-ff4307f52055
			summarizeBy: none
			sourceColumn: Year Week
			sortByColumn: 'Year Week Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// The numeric day of the month (1 to 31).
		column 'Day Of Month'
			dataType: int64
			formatString: 0
			lineageTag: 596a142d-0948-4863-adb4-07276c2dfee7
			summarizeBy: none
			sourceColumn: Day Of Month

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key combining year and quarter (e.g. 20231). Used to sort Year Quarter correctly.
		column 'Year Quarter Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 43f65660-5dc4-473e-afc5-b82046ed5316
			summarizeBy: none
			sourceColumn: Year Quarter Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Combined year and quarter label (e.g. 2023 Q1). Sort by Year Quarter Key to ensure correct chronological order.
		column 'Year Quarter'
			dataType: string
			lineageTag: 75c26fc2-9cfc-404d-b40f-56199bb756df
			summarizeBy: none
			sourceColumn: Year Quarter
			sortByColumn: 'Year Quarter Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key combining year and month in YYYYMM format. Used to sort Year Month correctly.
		column 'Year Month Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 3544a675-c536-4185-af0f-b5b94249206a
			summarizeBy: none
			sourceColumn: Year Month Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Combined year and month label (e.g. 2023 Jan). Sort by Year Month Key to ensure correct chronological order.
		column 'Year Month'
			dataType: string
			lineageTag: ed30f742-0333-4994-a03a-912a8e6fc106
			summarizeBy: none
			sourceColumn: Year Month
			sortByColumn: 'Year Month Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// The financial year label (e.g. FY2024). Based on a financial year starting 1 April — FY2024 runs from 1 April 2023 to 31 March 2024.
		column 'Financial Year'
			dataType: string
			lineageTag: f9452e0d-6915-4192-ac71-f1a832ab57d4
			summarizeBy: none
			sourceColumn: Financial Year
			sortByColumn: 'Financial Year Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// The financial quarter label (e.g. FQ1). Based on a financial year starting 1 April — FQ1 runs April to June, FQ2 July to September, FQ3 October to December, FQ4 January to March.
		column 'Financial Quarter'
			dataType: string
			lineageTag: d5a6a862-70b6-42e0-87dc-eaabd9ac51eb
			summarizeBy: none
			sourceColumn: Financial Quarter
			sortByColumn: 'Financial Quarter Key'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for the calendar year. Used to sort the Year column correctly.
		column 'Year Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: d82fe59b-8d6a-4b42-bed5-202031d4a42d
			summarizeBy: none
			sourceColumn: Year Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for financial year. Used to sort the Financial Year column correctly. Based on a financial year starting 1 April.
		column 'Financial Year Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 8cbdd4e3-4d99-43ea-bf1c-bcec9c2329e3
			summarizeBy: none
			sourceColumn: Financial Year Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for financial quarter. Used to sort the Financial Quarter column correctly. Based on a financial year starting 1 April.
		column 'Financial Quarter Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 378e0c65-923e-42cd-bb4d-be7f4329f1b0
			summarizeBy: none
			sourceColumn: Financial Quarter Key

			changedProperty = IsHidden

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key for half-year (1 or 2). Used to sort the Half column correctly.
		column 'Half Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 1c4717d0-1cbd-476c-8ec6-7162db42e24b
			summarizeBy: none
			sourceColumn: Half Key

			annotation SummarizationSetBy = Automatic

		/// The half-year label (e.g. H1, H2). Sort by Half Key to ensure correct chronological order.
		column Half
			dataType: string
			lineageTag: 7062921c-c116-4f98-b3c2-a07e7cb8e4ff
			summarizeBy: none
			sourceColumn: Half
			sortByColumn: 'Half Key'

			annotation SummarizationSetBy = Automatic

		/// Numeric sort key combining year and half-year. Used to sort the Year Half column correctly.
		column 'Year Half Key'
			dataType: int64
			isHidden
			formatString: 0
			displayFolder: Keys
			lineageTag: 79aae22b-c2a7-44de-a336-cd3926984544
			summarizeBy: none
			sourceColumn: Year Half Key

			annotation SummarizationSetBy = Automatic

		/// Combined year and half-year label (e.g. 2023 H1). Sort by Year Half Key to ensure correct chronological order.
		column 'Year Half'
			dataType: string
			lineageTag: 998b0193-a7eb-4eb0-8dbe-e5bbe06c4295
			summarizeBy: none
			sourceColumn: Year Half
			sortByColumn: 'Year Half Key'

			annotation SummarizationSetBy = Automatic

		hierarchy Calendar
			lineageTag: 826f17ed-b9d4-4b57-ad5d-7c536614e209

			level Year
				lineageTag: 7ed4e3ce-e11c-42d1-acc0-2cbf4c7d167f
				column: Year

			level Quarter
				lineageTag: a2301d84-4e77-41ab-a86b-01e70ebbb158
				column: Quarter

			level Month
				lineageTag: c1499bcc-3fa3-4c39-be30-f7f875d1b8ab
				column: Month

			level Date
				lineageTag: f2b93c57-8c35-498c-b47f-f5d7ecf44c9b
				column: Date

		hierarchy Financial
			lineageTag: d6839955-5ba9-4db2-9116-913ddadf739f

			level 'Financial Year'
				lineageTag: 8e426441-e920-49b3-aaee-ee1d8301632c
				column: 'Financial Year'

			level 'Financial Quarter'
				lineageTag: 20d2d1bf-c616-4328-93a4-97935e85ac9a
				column: 'Financial Quarter'

			level Month
				lineageTag: 1413ef2a-e443-471e-b4cb-5e7f3e64f2fe
				column: Month

		partition Dates = m
			mode: import
			source =
					let
					    Source = Excel.Workbook(AzureStorage.BlobContents("https://zomalextrainingstorage.blob.core.windows.net/datasets/misc/Dates.xlsx"), null, true),
					    Dates_Table = Source{[Item="Dates",Kind="Table"]}[Data],
					    #"Changed Type" = Table.TransformColumnTypes(Dates_Table,{{"Date", type date}, {"Month Key", Int64.Type}, {"Month", type text}, {"Quarter Key", Int64.Type}, {"Quarter", type text}, {"Year", type text}, {"Day Of Week Key", Int64.Type}, {"Day Of Week", type text}, {"Week Key", Int64.Type}, {"Week", type text}, {"Year Week Key", Int64.Type}, {"Year Week", type text}, {"Day Of Month", Int64.Type}, {"Year Quarter Key", Int64.Type}, {"Year Quarter", type text}, {"Year Month Key", Int64.Type}, {"Year Month", type text}, {"Financial Year", type text}, {"Financial Quarter", type text}, {"Year Key", Int64.Type}, {"Financial Year Key", Int64.Type}, {"Financial Quarter Key", Int64.Type}, {"Half Key", Int64.Type}, {"Half", type text}, {"Year Half Key", Int64.Type}, {"Year Half", type text}})
					in
					    #"Changed Type"

		annotation PBI_NavigationStepName = Navigation

		annotation PBI_ResultType = Table