let Source = Csv.Document(File.Contents("D:UsersswaipDownloadsraw_data_metrics.csv"),[Delimiter=",", Columns=9, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"KEY", type text}, {"VALUE", type number}, {"MODEL_NAME", type text}, {"METRIC_GROUP", type text}, {"COUNTRY", type text}, {"DATE_TIME", type datetime}, {"RUN_ID", type text}, {"ENV", type text}, {"_METADATA_FILE_NAME", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each true),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows",
latest = List.Max(#"Filtered Rows"[DATE_TIME]) in each Text.StartsWith([METRIC_GROUP], "prediction") and [DATE_TIME] = latest),
#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows", each Text.StartsWith([METRIC_GROUP], "training")) in #"Filtered Rows1"
combined = #"Filtered Rows1" & #"Filtered Rows2",
或
combined = Table.Combine({#"Filtered Rows1",#"Filtered Rows2"}),
如果它们具有相似的列结构,则将第二个附加到第一个。