Merging of three datasets

[DLM0830]

Hi! 

I am new to power bi and I would just like to ask if it can merge three datasets (excel) even though the relationship is many to many and they also don't have any unique key.

Your response will be much appreciated and Thank you.

[RoboticPea]

Do they share any feature, like a column?

[DLM0830]

They do share a feature but I still have to extract it from a cell which is what I am doing using a split column. But it is a bit hard since some feature(row) doesn't exist in other datasets. (purchase order and sales order). Like, they have some columns which are almost the same (items) but they are some items in purchase order line that doesn't exist in sales order line.

[v-piga-msft]

Hi @DLM0830,

Could you share some data sample which could reproduce the scenario and your desired output so that we could help further on it?

Best Regards,

Cherry

[Greg_Deckler]

Maybe? Can you post sample data?

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/38490