Forum Discussion
Solved
Aggregate columns in table visual
Hello I have table like this in power bi But the goal this to build a visual with table like this Does anyone know how to build this?
For Power Query (M language), you can achieve a similar result by grouping rows based on a specific column and then combining the values of the other columns using the Text.Combine function. Here’s an example of how to do this:
let Source = YourTableName, GroupedRows = Table.Group(Source, {"YourGroupColumn"}, {{"CombinedColumn", each Text.Combine([YourColumnToCombine], ", "), type text}}) in GroupedRows
For Power Query (M language), you can achieve a similar result by grouping rows based on a specific column and then combining the values of the other columns using the Text.Combine function. Here’s an example of how to do this:
let
Source = YourTableName,
GroupedRows = Table.Group(Source, {"YourGroupColumn"}, {{"CombinedColumn", each Text.Combine([YourColumnToCombine], ", "), type text}})
in
GroupedRows