Forum Discussion
Power Query, Question - Unique name for grouped values buying and selling to each other @ same time?
Hello.
happy Sunday everyone. This prob is super easy for yall, but i just cant figure it out. In Power Query, I have a list of 53 Customer and Vendor families buying and selling from each other simultaenously inside my data of 6000 invoices. I used Advanced Group By to group Vendors and Customer Family Names, values. Screenshot 1 below. I've I'm trying to create a unique group name for each bilateral relationship (buyer/seller, seller/buyer), e.g. for Screenshot 2 below example. Any ideas? Any help would be so greatly appreciated... thank u very much 🙂
Unique Bilateral Relationship I am trying to create a logicaly way to assign a unique name to the relationship below, but since the vendor family names and customer family names are flipping, I just cant get come up with anything to bring them together in a name.
Milestone I *think* if you assign a prime number value to each family then the sum of those two numbers would provide a unique identifier.
2 Replies
Milestone I *think* if you assign a prime number value to each family then the sum of those two numbers would provide a unique identifier.
You are amazing. Thank you so much. Slight change. but you totally nailed it. The product of two primes produces a unique number, not the sum is the only step out change i needed, but i never would have even gotten close to this without your amazing help. Thank you so much.
