table AIA_AdvanceAnalysis_Subchannel
	lineageTag: 669bd2ed-cd1a-4054-a745-824bc171cd86

	column SUB_CHANNEL
		dataType: string
		lineageTag: 8d030a17-0c91-4c24-9dde-29ad769b6553
		summarizeBy: none
		sourceColumn: SUB_CHANNEL
		sortByColumn: SUB_CHANNEL_ORDER

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column SUB_CHANNEL_ORDER
		dataType: int64
		formatString: 0
		lineageTag: d40b632c-ae6f-4ef0-ab4a-8908a92cae88
		summarizeBy: none
		sourceColumn: SUB_CHANNEL_ORDER

		annotation SummarizationSetBy = Automatic

	partition AIA_AdvanceAnalysis_Subchannel = m
		mode: import
		queryGroup: 'AIA 独有表'
		source = ```
				let
				    Source = Dim_RC,
				    #"Filtered datasource aia" = Table.SelectRows(Source, each [DATA_SOURCE]= "AIA(Monthly)"),
				    #"Removed Other Columns" = Table.SelectColumns(#"Filtered datasource aia",{"SUB_CHANNEL", "SUB_CHANNEL_ORDER"}),
				    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns", {"SUB_CHANNEL"}),
				    #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each [SUB_CHANNEL] <> null and [SUB_CHANNEL] <> ""),
				    #"Appended Query" = Table.Combine({#"Filtered Rows", 
				    Table.FromRecords({   [SUB_CHANNEL = "Market", SUB_CHANNEL_ORDER = -1]})}),
				    #"Changed Type" = Table.TransformColumnTypes(#"Appended Query",{{"SUB_CHANNEL_ORDER", Int64.Type}})
				in
				    #"Changed Type"
				```

	annotation PBI_NavigationStepName = Navigation

	annotation PBI_ResultType = Table