Forum Discussion
Helper ICreating groups based on numbers
Did you remove the duplicates in your bridge table??
If not, then remove it.
Also it doesn't matter how many every repeating values you have in your table. Since you are going to remove the duplicates from your bridge table, your bridge table will act as a unique key for joining the tables
Super UserHi rhborders,
Between your Fact Table in Power BI and the New Calculated table, introduce a new bridge table that will have only one column. This column will be the concatenation of CustomerID and ProductID.
Now join your fact table and Calculated table through this bridge table
Note: Your fact table and Calculated table also will have the concatenated column. Only then you can connect the tables
Something similar to the image given below
Helper IHey Thejeswar,
I tried to do this and ran into the problem of having repeat values so it couldn't be a unique key. In both my customer ID and Product ID I have -1 representing when our company makes a sale versus one of our sales reps making a sale. This results in the multiple values that repeat. I had tried to write out a function that filtered out the -1 but couldn't find one that worked.
- Thejeswar
Did you remove the duplicates in your bridge table??
If not, then remove it.
Also it doesn't matter how many every repeating values you have in your table. Since you are going to remove the duplicates from your bridge table, your bridge table will act as a unique key for joining the tables