table Dim_Unit lineageTag: a33e52b2-3e53-45fa-a367-35c81ff99fed column DW dataType: string lineageTag: bbb4b5ae-3eb0-4195-99cc-51ea45eab487 summarizeBy: none sourceColumn: DW sortByColumn: ORDER1 changedProperty = SortByColumn annotation SummarizationSetBy = Automatic column ORDER1 dataType: int64 formatString: 0 lineageTag: 13b30ae0-89b5-4e22-ad7f-8e20f47152b3 summarizeBy: sum sourceColumn: ORDER1 annotation SummarizationSetBy = Automatic column DW_TYPE = SWITCH([DW], "RMB","Value", "K RMB","Value", "M RMB","Value", "USD","Value", "K USD","Value", "M USD","Value", "Unit","Unit", "K Unit","Unit", "M Unit","Unit", "PDOT","PDOT", "K PDOT","PDOT", "M PDOT","PDOT", "CU","CU", "K CU","CU", "M CU","CU") lineageTag: 60c98a25-1f7c-4615-ba23-f9bb41c7b024 summarizeBy: none annotation SummarizationSetBy = Automatic column ShowCurrency = ``` IF ( SELECTEDVALUE('Dim_DataSource'[DATA_SOURCE]) = "XieHe", 1, IF ( 'Dim_Unit'[DW] IN {"Rx", "K Rx", "M Rx"}, 1, 0 ) ) ``` formatString: 0 lineageTag: b87ccd37-43c7-4653-a2c7-5e69cbe16dbb summarizeBy: sum annotation SummarizationSetBy = Automatic partition Dim_Unit = m mode: import queryGroup: EXTERNAL_辅助表 source = let 源 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Nc8tDoAwDIbhq5BqBIPBwMIcWSD8qIUDYFAIjs/Wr3V9kjdpGyNtYaSSDF1lpLmAalYQNaxz92m20kGtdFCH7rnfBKch2GsJDszVL0feXUmrNhKrcc505rmRFrJSQjhn+/Lc6UMspw+x0jHXDw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [DW = _t, ORDER1 = _t]), 更改的类型1 = Table.TransformColumnTypes(源,{{"ORDER1", Int64.Type}}), 删除的底部行 = Table.RemoveLastN(更改的类型1,2), 替换的值 = Table.ReplaceValue(删除的底部行,"Rx","张数",Replacer.ReplaceText,{"DW"}) in 替换的值 annotation PBI_ResultType = Table