Combining two columns from two table for creating a new table

[unnijoy]

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.

[V-lianl-msft]

Hi @unnijoy ,

 It is a common problem between calculate column and relationship.

https://www.sqlbi.com/articles/understanding-circular-dependencies/ 

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/ 

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.

[amitchandak]

Can you share relationship diagram

[Tara_]

Hi @unnijoy ,

Can you use Power Query? This way you can merge the tables by Month for the month table and Country for the other. 

[unnijoy]

i don't understand. Can you explain