Forum Discussion

rickferreiran's avatar
rickferreiran
Helper I
2 years ago
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?

Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    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

2 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    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