Forum Discussion
Create a column with results based on multiple rows per a grouping ID
=let a=Table.Group(PreviousStepName,"Product ID",{"n",each if List.Contains([FOUND],"FOUND") then "FOUND" else "NOT FOUND"}) in Table.AddColumn(PreviousStepName,"NewCol",each a{[Product ID=[Product ID]]}[n])
=let a=Table.Group(PreviousStepName,"Product ID",{"n",each if List.Contains([FOUND],"FOUND") then "FOUND" else "NOT FOUND"}) in Table.AddColumn(PreviousStepName,"NewCol",each a{[Product ID=[Product ID]]}[n])
Wow, thank you! This did work! I will definitely mark this as the answer, but before I do, can I ask if you happen to know if what this code does is doable just using the interface (without using M)? I'm sure this further betrays my lack of experience with PQ. I kept wanting to do somehting akin "For Each" Grouped ID. Is that what is happening in your code at the "each a" part?
Thank you so much, once agian.
