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 that I can work with the sales and forecast data from the two different tables. However, I am getting a circular depency error, see below. What could I do to solve this? Thanks. Rex

 

 

Need Help

2 Replies

  • 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.