Forum Discussion
Solved
Create 2 one to many relationships to same table?
My transaction table has columns for sending location, receiving location, and quantity. I need to calculate location balance by summing the quantities for all transactions where the location is the ...
Thanks for the replies. I decided to use Power Query to make two partial copies of the table: one for the sender point of view and one for the receiver point of view.
Thanks for the replies. I decided to use Power Query to make two partial copies of the table: one for the sender point of view and one for the receiver point of view.