Forum Discussion
Solved
Circular dependency
i have 2 tables, customers and salesteam. in the customers table, i have a column sales team that was added with a lookup() dax function that gets the Salesteam[salesteam.name] by doing a lookup on t...
Hello, Hussein_charif ,
I would try removing all calculated columns in both tables and redo them in Power Query.
Then I would try again.
My theory is that a couple of columns need both tables alive and functioning. Which would not be case with remove lookup.
i re-did the column in power query by a merge, and it worked, thank you!
Hussein_charif amazing, happy to help.