table AIA_AdvanceAnalysis_Decile
	lineageTag: 0b24affa-31b0-411f-90c3-c84335e80666

	column DECILE
		dataType: string
		lineageTag: 4f944666-1079-4c5d-b8aa-20d51d996c9f
		summarizeBy: none
		sourceColumn: DECILE
		sortByColumn: DECILE_ORDER

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column DECILE_ORDER
		dataType: int64
		formatString: 0
		lineageTag: 7d1cb240-7c05-41f0-a8af-f40d8f02138d
		summarizeBy: none
		sourceColumn: DECILE_ORDER

		annotation SummarizationSetBy = Automatic

	partition AIA_AdvanceAnalysis_Decile = m
		mode: import
		queryGroup: 'AIA 独有表'
		source = ```
				let
				    Source = Dim_HP_Potential_AIA,
				    #"Filtered datasource aia" = Table.SelectRows(Source, each [DATA_SOURCE]= "AIA(Monthly)"),
				    #"Removed Other Columns" = Table.SelectColumns(#"Filtered datasource aia",{"DECILE"}),
				    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns", {"DECILE"}),
				    #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each [DECILE] <> null and [DECILE] <> ""),
				    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"DECILE", Int64.Type}}),
				    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"DECILE", Order.Ascending}}),
				    #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "DECILE_ORDER", 0, 1, Int64.Type),
				    #"Changed Type1" = Table.TransformColumnTypes(#"Added Index",{{"DECILE", type text}}),
				    #"Appended Query" = Table.Combine({#"Changed Type1", 
				    Table.FromRecords({   [DECILE = "Market", DECILE_ORDER = -1]})}),
				    #"Changed Type2" = Table.TransformColumnTypes(#"Appended Query",{{"DECILE_ORDER", Int64.Type}})
				in
				    #"Changed Type2"
				```

	annotation PBI_NavigationStepName = Navigation

	annotation PBI_ResultType = Table