Page 1 of 1

Relationship issue

Posted: Mon Dec 16, 2019 6:32 pm
by Franz
Hi

I have a relationship issue and cannot figure out what is causing it :-(

I want to connect the tables "FTE" and "WBS". The table "CATS" tells me how the entries are linked. There is an additional issue in the sense that WBS is only linked on an aggregated level (WBS Code) i.e. there is a many to many relationship for which I inserted a List of unique entries.

[attachment=0]Relationship.jpg[/attachment]

I don't actually need to calculate anything, I just need list of combinations.

Many thanks for any tips on how to solve my problem.

Regards
Franz

Re: Relationship issue

Posted: Mon Dec 16, 2019 6:59 pm
by RamanaV
Can you share a sample workbook?

Want to look at the data and then look at the relationships to resolve the issue

Thanks

Re: Relationship issue

Posted: Tue Dec 17, 2019 7:27 am
by Franz
Hi Ramana

Please find attached a sample workbook (I deleted a few extra columns from the earlier screenshot version)
Any help is much appreciated.

Regards
Franz

Re: Relationship issue

Posted: Tue Dec 17, 2019 9:33 am
by RamanaV
You can actually merge the data before loading into data model using Power Query (Get Data -> Transform Data).
I have given the solution in the attached workbook
You can see the final data table loaded into Excel

Hope this helps

Re: Relationship issue

Posted: Wed Dec 18, 2019 1:15 am
by Franz
Hi Ramana

Many thanks for your help.
Your solution is actually quite simple and straight forward.
I got somehow stuck with the idea that this should be solvable with relationships. Your idea is smarter.

Best regards
Franz