Forum Discussion
Remove duplicates not working.. Can't create relationship
Hello, I have a dataset with customer and a discount structure for that customer per part. I created a concatenate in the edit query screen of the customer, and there are a couple duplicates. Hig...
Yes, I double and triple checked. Everything was done the same way as in my example. Must be an error due to such a large data set.
Greg_Deckler
Community Champion
Community ChampionWould have to see some sample data where the problem could be reproduced.
The same exact steps in the edit query in this situation worked. They do not with my large data set (10 Million lines & about 20 duplicates).
- Greg_Deckler
I would report this as an Issue: https://ideas.powerbi.com/forums/360879-issues
Bummer.. Well I just ended up making another table to mirror the first, linked the summary table, and filtered all the ones. it worked, but with this many lines I'd rather have it be more efficient. Thanks for your help Greg_Deckler