Forum Discussion
Many To Many relationship
Hi all,
Kindly assist, I'm still new to Power BI. I'm trying to read the targets from Target's table to the 2020 sales but I'm not getting the desired/unique results.
The targets are per Month, per Category, per Region, per Channel and I'm struggling to get unique values for this.
TargetFile
Tables
I have tried linking the 2020 table with Targets table using the "MONTH" field but the results are the same,
VVis
1 Reply
what is the relationship between? you need to create the relationship on channel between 2020 and targets, the date table should be linked separately to the target, not through 2020, and it would be better to have a lookup table called channel and then you link both the target and 2020 to that table.
