Remove grouped duplicates in powerquery

[Syndicate_Admin]

Greetings dear. I tell you, it turns out that I have to group some data by month and, based on each month, remove the IDs of duplicate users (only in the month). I have no problem grouping the data by month but, when I have the count of the photograph I can not apply the "remove duplicates" that I need.

How can I solve this problem?

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Please try to expand the table first, then select the two column that you want to remove duplicates, finally click "remove duplicates"

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Syndicate_Admin 

pls try expand the table first, then remove duplicates.

If this cannot solve your problem, pls provide the sample data and expected output.