Forum Discussion
Table Relationship
Hello
I have a table in powerpivot data model two tables linked to each other through a one to many relationship. the link is dne through the key "Role"
In the one side table I have put two colums the first one is the role ( role of a sales representative) which is a unique key and then a second one is the type of business ( entity or destination)
I defined all the roles known in the table that are entity and all rest of the roles that are not defined in this table should be destination. which means All other role not defined in the table should be "Destination"
I am not able to implement this as it's giving me an error.
please advise
23 Replies
- Hi Imed
When you say you can't implement this do you mean it won't let you join the 2 tables together?Yes exactly.
what I want to to do is as follow
in table 1 I have a column specifying different roles
Table 2 is defining the role and the type of P&L ( profit and Lost)
I am interested only by some roles for instance
Role_name P&L
Role 1 Entity
Role 2 entity
Role 3 entity
and I would like to specify all other roles should be destination
how to do this.
thank you for your support.
regards,
- You will need to list all roles and state each one is Destination. Any roles not mapped will show as Blank
One option would be to do the mapping using Merge Queries in Power Query and then replace all the nulls with Destination
