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...
pselliott Can you merge the datasets in power query editor to create a unified table that includes the necessary fields (Customer ID, Meeting Date, Email Date).
Then expand the merged table to include the meeting date and email date.
And then add a custom column to calculate the difference in days between the Meeting Date and Email Date
= Duration.Days([Email Date] - [Meeting Date])
Then remove duplicate record and load the data to the power bi interface and begin your analysis.