Relationship issue

[gbarr12345]

Hi there,

I have data in excel that I've imported into Power BI.

The only issue is that both of the data is transactional data and I need them to connect.

The only relationship I can only do is a Many to Many which I know isn't reliable.

Can anybody help me in fixing the relationships please if possible?

I have attached the sample PBIX and sample data I created which mirrors the data I was provided (with different headings and numbers of course). Please see below:

PBIX - https://drive.google.com/file/d/10yZDO4Q7RqrIw02WPlZ0fglhcrtiMpCi/view?usp=drive_link

Excel - https://docs.google.com/spreadsheets/d/1ot6UL-7Hmbz0YHxxDhxSMaOMYyAKj3lb/edit?usp=drive_link&ouid=11...

[Ritaf1983 · Accepted solution]

Hi @gbarr12345 

o answer your question, it's necessary to understand the logic behind what you're trying to do, as it’s not clear at this moment.

On a technical level, the tables appear to have the same structure, so it’s unclear why you’re not performing a union (combining them vertically with a classified column if they represent different actions). The many-to-many relationships that have been created are due to the lack of a unique key for each table. Technically, you could address this by creating a bridge table, but that’s only part of the solution, as it’s not clear what you’re trying to achieve logically.

More information about many-to-many and bridges tables is here :

https://www.youtube.com/watch?v=aPLaun-tTgQ

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[gbarr12345]

Thanks very much for your help Rita! Much appreciated!

[Ritaf1983]

Happy to help☺️