Forum Discussion
unnijoy
Post Prodigy
Post ProdigyCombining two columns from two table for creating a new table
Hi All,
I have two table and have common columns.
1.Month
2.Country
Now i need to create 2 tables once for Month and the other for Country
I use the below dax
Month= DISTINCT(UNION(VALUES('HC Data'[Month]),VALUES('Raw Data - Aug to Oct 19'[Completed Month])))
Countr = DISTINCT(UNION(VALUES('HC Data'[Country]),VALUES('Raw Data - Aug to Oct 19'[Country])))
But when i try to creat a relationship with his two table it is giving me an error saying Circular Dependency.
How can i fix this. Please help.
4 Replies
- unnijoy
i don't understand. Can you explain
- amitchandak
Super User
Can you share relationship diagram
V-lianl-msftCommunity Support
Hi unnijoy ,It is a common problem between calculate column and relationship.You can upload sample pbix file and expected output to OneDrive for Business and post the link here. (Please mask any sensitive data before uploading)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
