Forum Discussion
Solved
Remove 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.
Can you explain what you are looking for?
You can do anything in a group by that you can do in a normal table.
