Forum Discussion
Editor: how to remove duplicates selectively based on the condition
Hi All, I use PowerBI to analyze efficiency of our mass email campaigns. I get a table that contains all emails that were sent. Each row is for one email message to one email address, e.g.: ...
ElenaN , thank you, but it didn't help. However now I know about this feature :)
I still get the list with the only first email
Here is what I did:
ElenaN
Resolver V
Resolver VHello,
Reacted Date should not be in the grouping but only in the new column part.
Regards,
ElenaN
Elena, thanks! Well, I could get a list of email addresses and date, but if I add more fields (which I need), this solution stops working for me :(
I need to get a list of emails with three more columns: subject, email number and reacted date
- ElenaN
Hello,
So, under Group By section you should pick the Email, Subject and Email # fields and under New column name you should have MAX Reacted Date.
If you have these, what happens? What is your end result?
Regards,
ElenaN