Forum Discussion
RELATIONSHIP HELP!
Hi All,
I have 3 sets of data. 1. The company name and location 2. The current customers and the company and 3. Potential customers. All 3 sets of data can be matched up by the Company name however it does not seem to be working for me. Depending on how I link up the relationships only ~3/30 are able to match.
My data is 3 sheets: Core, Customer, Pipeline. I merged the Cores and Customer sheets as one so each customer has the location of the company with it.
This is the output: (p is pipline, merge is the coresandcustomer)
You can see that the Pipleine->Core works fine and matches but for some reason when you do Pipeline->Customer it does not and neither does the Merge->Pipeline. Does anyone know how to fix it so the Pipeline->Merge gives the same output that the Pipeline->Core does?
Thank you!
4 Replies
Hi alisonpappas ,
Seems the structure of the table cannot be completely determined in your picture and the relationship like Core and Core Business.
Could you please consider sharing a sample file for further discussion?
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-yingjl how do i share a smaple? in excel file or pbx?
- where are you doing this join, in the relationship view or in power query? have you check for white spaces ie trim / cleaning both fields in power query ?
