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.