Forum Discussion
DaveCor
Helper I
Helper IRemove duplicates but consolidate data from other columns
Hi folks, First time poster and recent convert to Power BI but using Excel for many years. I have a table that I want to later merge with another table but first I need to do some work to i...
Table.Group(PreviousStep, "ID", {{"ADR", each List.Select([ADR], each _ <> "" and _ <> null){0}?}, {"ADV", each List.Select([ADV], each _ <> "" and _ <> null){0}?}})Where PreviousStep is your previous step in the query.
artemus
Microsoft Employee
Microsoft Employee
Table.Group(PreviousStep, "ID", {{"ADR", each List.Select([ADR], each _ <> "" and _ <> null){0}?}, {"ADV", each List.Select([ADV], each _ <> "" and _ <> null){0}?}})
Where PreviousStep is your previous step in the query.
DaveCorThank you artemus!
I tried a load of different types of "Group By" but couldn't get this to work. As a matter of interest, would it actually be possible to do what I was looking for using the "Group By" window or does it require the code you've provided?
