One to Many Relationship

Question

Hi,Can you please review below ?I have &nbsp;2 souce tables,Source:1 has relationship with Source:2 (One to Many).I want to display records from Source:1 Price column to Source 2: Price Column.I have tried RELATEDTABLE and did not gave me any result.Please provide your suggestions.Thanks&nbsp;Salesforce Source:1&nbsp;Salesforce Source:2IdPrice&nbsp;IdPriceABC123&nbsp;ABC&nbsp;&nbsp;&nbsp;&nbsp;ABC&nbsp;&nbsp;&nbsp;&nbsp;ABC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Salesforce:2 (Expected Result)&nbsp;&nbsp;&nbsp;IdPrice&nbsp;&nbsp;&nbsp;ABC123&nbsp;&nbsp;&nbsp;ABC123&nbsp;&nbsp;&nbsp;ABC123&nbsp;&nbsp;

anonymous · Answer

Hi Anonymous&nbsp;Is this something that you're after ?

anonymous · Answer

Hi Lw,Thank you so much for your response.In my source 2 table has duplicate records in ID column and i want to pull Price from Source 1 has all unique values.My Expected Result should be,ID&nbsp; &nbsp; &nbsp;PriceABC&nbsp; 123ABC&nbsp; 123ABC&nbsp; 123

jdbuchanan71 · Answer

In your table visual, under the price, you can set the field to not summarize which will give you the multiple rows.&nbsp; Is that what you are looking for?

anonymous · Answer

Hi,My source 1 column “ID” has all the unique value and Source 2 column “ID” has multiple duplicate values. Source 1 has column “PRICE” .So my reuirements is that if Source 1 column “id” match with Source 2 column “id” then copy all the “PRICE” from Source 1 to Source 2 “PRICE” column.If source 1 (id)=source 2 (id)Then source 1 (price) should copy to source 2 &nbsp;“price”column.(Source 2 “id” has duplicate records).I have tried to use lookup and relatedtable but no luck,Lookup(source 1 (price),source 1 (id),source 2 (id))Let me know if you need more explaniations.Thanks

anonymous · Answer

Hi, Please make sure the relationship is set correctly. Try to remove the duplicate in Source2 if possible in Power Query.

Forum Discussion

One to Many Relationship

8 Replies

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships

Salesforce Source:1		Salesforce Source:2
Id	Price		Id	Price
ABC	123		ABC
			ABC
			ABC


		Salesforce:2 (Expected Result)
		Id	Price
		ABC	123
		ABC	123
		ABC	123