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 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