Forum Discussion
koorosh
4 years agoPost Partisan
Add columns
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.
3 Replies
- kooroshPost PartisanCountry = LOOKUPVALUE(DimGeography[EnglishCountryRegionName],DimGeography[GeographyKey],FactInternetSales[SalesTerritoryKey])
- v-luwang-msftCommunity Support
Hi koorosh ,
Could you pls show me your pbix file and expect output result?And remove confidential data.
Best Regards
Lucien
- kooroshPost Partisan
https://community.powerbi.com/t5/Desktop/Add-column/m-p/2066152#M770868
Could you please refer to above one?