Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Circular depency error on UNION table

Hey all,   I have created a UNION table to create a table with all Customer IDs from two source (one source contains less customer IDs and some 0's). I want to create a one to many relationship so ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , use distinct

distinct(union(distinct(Table1[Customer ID]),distinct(Table2[Customer ID])))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey Amit,

 

Thanks but now a many-to-many relationship is the only one available. See below, how can I make it a one to many? Because a customer can have multiple saleslines but a salesline can only have one customer.