Forum Discussion
A complex remove duplicates. Please help.
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may add a new step like below.
= Table.SelectRows(#"Changed Type",each let x = [New Hire Name], y=Table.RowCount( Table.SelectRows(#"Changed Type",each [New Hire Name]=x) ) in (y>1 and [Start Date]<>null) or y=1 )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
What is your logic to remove the record?
Do want to remove the lines for new hire names that have at least one record with start date?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
I need to show if a new hire has been hired again, but also need to show if their name wasn't included in the new hire list provided to me. I am basically given two new hire list and one has a bunch of info with it including start dates and the other is pretty much just their name. If they are in the second list that has no info, but not in the first list, I need to keep it so I can get the rest of their info, but if they are in the first list multiple times, I need to keep all instances of their name in that list.
this might be a nestedjoin problem. you can provide some sample data of these two tables.
