Add columns

[koorosh]

Hello Experts, In Adventure_Work file we have "sales territory key" column in the DimGeography table and FactInternationalSales. And the two tables have many to many relationship through this column. How can I add "Geography Key" column from DimGeography table to FactInternationalSales table so there would be a one-to-many relation between DimGeography and factInternationalSales tables through Geography Key column. 

[v-luwang-msft]

Hi @koorosh ，

Could  you pls show me your pbix file and expect output result?And remove confidential data.

Best Regards

Lucien

[koorosh]

https://community.powerbi.com/t5/Desktop/Add-column/m-p/2066152#M770868

Could you please refer to above one?

[koorosh]

Country = LOOKUPVALUE(DimGeography[EnglishCountryRegionName],DimGeography[GeographyKey],FactInternetSales[SalesTerritoryKey])