table Fact_Retail_Special
	lineageTag: 03270d86-cd05-4e82-8d9b-3c07a61ae07d

	column market
		dataType: string
		lineageTag: 211934fd-fc53-4f05-9e64-a6f76b1f3a92
		summarizeBy: none
		sourceColumn: market

		annotation SummarizationSetBy = Automatic

	column province_city
		dataType: string
		lineageTag: eddc6fc4-9197-4ddb-89e6-caa5c30ccfca
		summarizeBy: none
		sourceColumn: province_city

		annotation SummarizationSetBy = Automatic

	column audit_key
		dataType: string
		lineageTag: 1b0c5594-91ae-4c6d-9dc5-af16099da672
		summarizeBy: none
		sourceColumn: audit_key

		annotation SummarizationSetBy = Automatic

	column yyyymm
		dataType: string
		lineageTag: badbdb34-9b05-4c44-b865-738549ab9d64
		summarizeBy: none
		sourceColumn: yyyymm

		annotation SummarizationSetBy = Automatic

	column sales_value
		dataType: double
		lineageTag: f02a1e51-8f8d-46e8-a145-f75b5be718af
		summarizeBy: sum
		sourceColumn: sales_value

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column sales_volume
		dataType: double
		lineageTag: 9266f441-b1f7-47e0-825c-eb594ab31e99
		summarizeBy: sum
		sourceColumn: sales_volume

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column pdot_counting_unit
		dataType: double
		lineageTag: a5affad6-965f-4513-a231-a8285fdf40ed
		summarizeBy: sum
		sourceColumn: pdot_counting_unit

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column audit_source
		dataType: string
		lineageTag: b46c7620-5dcf-4c87-906f-327a8b0d2170
		summarizeBy: none
		sourceColumn: audit_source

		annotation SummarizationSetBy = Automatic

	column date_key
		dataType: dateTime
		formatString: Long Date
		lineageTag: ce7abf1b-9099-41b3-bd06-af96c983648c
		summarizeBy: none
		sourceColumn: date_key

		changedProperty = DataType

		annotation SummarizationSetBy = Automatic

		annotation UnderlyingDateTimeDataType = Date

	column sales_value_ly
		dataType: double
		lineageTag: 4a689421-1ba3-4557-8830-3e3fc15d3b62
		summarizeBy: sum
		sourceColumn: sales_value_ly

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column sales_volume_ly
		dataType: double
		lineageTag: e1622402-5a58-4798-812a-226e529a8f41
		summarizeBy: sum
		sourceColumn: sales_volume_ly

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column pdot_counting_unit_ly
		dataType: double
		lineageTag: 0e63434c-ada9-43e7-974d-d5415e5dc395
		summarizeBy: sum
		sourceColumn: pdot_counting_unit_ly

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column rc_key
		dataType: string
		lineageTag: 52bdfe70-0b61-43b6-879d-edca0767cc39
		summarizeBy: none
		sourceColumn: rc_key

		annotation SummarizationSetBy = Automatic

	partition Fact_Retail_Special = m
		mode: import
		queryGroup: FreeReport独有表
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				    "
				select 
				  a.market
				  ,a.province_city
				  ,a.audit_key
				  ,a.audit_source
				  ,a.date_key
				  ,a.yyyymm
				  ,a.sales_value
				  ,a.sales_volume
				  ,a.pdot_counting_unit
				  ,a.sales_value_ly
				  ,a.sales_volume_ly
				  ,a.pdot_counting_unit_ly
				  ,concat(a.audit_source,a.market) rc_key
				from dm.dm_tf_external_retail_special a
				    "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				in
				    Source
				```

	annotation PBI_NavigationStepName = Navigation

	annotation PBI_ResultType = Table