Forum Discussion
Merging of three datasets
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 ...
Do they share any feature, like a column?
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-msftResident Rockstar
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