Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
1 year ago

grouping by ID

hello please see the attachment current versus the expected result. How can I achieve this in Power Query within Power BI. Note that the column PR&A Leader.title is a people picker columns I trie...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"ID"}, {{"Count", each Text.Combine([#"PR&A Leader.title"],","), type nullable text}})
in
    #"Grouped Rows"

Hope this helps.