Forum Discussion
Many-To-Many
Hello PBI community. I have been stuck on this particular problem for a few days and cannot seem to wrap my head around it. Currently, I have sales and target data in a table that is related to ...
I cannot create a relationship between these tables as there is no unique values on which to create the relationship.
Oh Sorry,
I forgot to mention, You have created those two tables and each has a single column.
- DimKAM for KAM
- DimSA for Sales Agent
I already have the correct tables with unique values down the bottom (KAM Information, Sales Agent Information etc).
The only table that does not contain unique values is the Hierarchy table.
Use those tables (KAM Information, Sales Agent Information etc) and create relationships with Sales Information and Targets