The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Hi @koorosh ,
Could you pls show me your pbix file and expect output result?And remove confidential data.
Best Regards
Lucien
https://community.powerbi.com/t5/Desktop/Add-column/m-p/2066152#M770868
Could you please refer to above one?
User | Count |
---|---|
86 | |
84 | |
35 | |
35 | |
34 |
User | Count |
---|---|
94 | |
79 | |
65 | |
55 | |
52 |