Forum Discussion
Connect relationship many-to-one
Im trying to connect 2 tables with a many-to-one relationship but when I choose column that should be considered primary, Power BI sends me this error message: "the selected column can't be the key ...
Hi Dhairya this is the data I want to set as the 'key column' but PBI is saying it contains duplicate values
| Level 4 | |
| Revenue: Integrations (Net) | |
| Revenue: Logistics (Net) | |
| Revenue: Other (Net) | |
| Revenue: Premium (Gross) | |
| Discounts: Premium | |
| Application hosting and monitoring costs | |
| Data communication costs | |
| Software license fees for embedded third-party apps | |
| App/Website development costs | |
| Salary costs: Customer Service | |
| Salary costs: Account Management | |
| Salary costs: Admin Operations | |
| Freelancers: Account Management | |
| Freelancers: Admin Ops | |
| Freelancers: Customer Service | |
| Travel: COGS | |
| Software & Tools: COGS | |
| COGS: Logistics | |
| Salary costs: Field Sales | |
| Salary costs: Vendor Management | |
| Salary costs: Implementation Management | |
| Salary costs: Inside Sales | |
| Salary costs: Markets Other | |
| Salary costs: Marketing | |
| Freelancers: S&M | |
| Travel: S&M | |
| Software & Tools: S&M | |
| Marketing | |
| Operations infrastructure software costs | |
| User Growth Expenses | |
| Salary costs: Engineering | |
| Salary costs: Product | |
| Salary costs: Design | |
| Salary costs: Solutions Engineering | |
| Freelancers: EPD | |
| Travel: EPD | |
| Software & tools: EPD | |
| Salary costs: Finance & Legal | |
| Salary costs: Global Operations | |
| Salary costs: IT Infrastructure | |
| Salary costs: Management | |
| Salary Costs: Other | |
| Salary costs: People Operations | |
| Salary costs: Special Projects & Supply Chain | |
| Freelancers: G&A | |
| HR & Payroll | |
| Finance & Legal | |
| Other OPEX (all) | |
| Recruiting | |
| Rent (all) | |
| Staff Entertainment | |
| Software & Tools: G&A | |
| Travel: G&A | |
| D&A | |
| Forex (Loss)/Gain: all | |
| Net interest expense | |
| Tax Expense | |
| Net Working Capital | |
| Depreciation & Amortisation | BS | |
| Other | BS | |
| Fixed Assets | |
| Equity Investment | |
| Bank | |
| Retained Earnings |