let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUjEyN1XSUTJUitUBcowNDBAcQyOQjBGEYwSWgXIMzZFkLMEyxkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Price = _t, Group = _t]),
#"Grouped rows" = Table.Group(Source, {"Group"}, {{"Count", each "[""" & Text.Combine([Price], """, """) & """]", type text}})
in
#"Grouped rows"
2条答案
按热度按时间3okqufwl1#
您只需要对
Group by
进行分组,并执行一些操作来添加引号和括号:c6ubokkw2#
您要寻找的答案是将
Table.Group()
函数与Text.Combine()
函数组合在一起。这将为您工作: