Forum Discussion
De-duplicating data within a certain timeframe
Hello, We have 3 data sets (1. Meetings, 2. Emails, 3. Customer). We want to count if an an email was generated for a specific Customer within 35 days of the Customers meeting. Sometimes mul...
Hi,
Thanks for the solution DallasBaba offered and i want to offer some more information for user to refer to.
hello pselliott , based on your description, you can use lIst.Distinct() funciton, you can refer to the following link about the function.
List.Distinct - PowerQuery M | Microsoft Learn
And can you provide some sample data so that can provide more suggestion for you.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.