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