|
这好端端的一维表(左边)工工整整,用起来多方便呀。。。
PQ里可以先做一下Table.Group再做Pivot
- let
- Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcivNSy7JzM8zVNJRckktKAHR2oYKPsZAOjw1NdtQKVYHU5URkNYFqjKBqjLCqsoYapYRVJUxVlUmULNgNppgVWUKNQtmoylWVWYQs4LxOt4MYhSSolgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Function = _t, #"Sub-Dept" = _t, Update = _t, Week = _t]),
- #"Grouped Rows" = Table.Group(Source, {"Function", "Sub-Dept", "Week"}, {"update", each Text.Combine([Update], "#(lf)")}),
- #"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[Week]), "Week", "update")
- in
- #"Pivoted Column"
复制代码 用DAX就更方便了,
- Concat = CONCATENATEX(DS, DS[Update], UNICHAR(10))
复制代码
|
|