Forum Discussion

aid928's avatar
aid928
Helper I
3 years ago
Solved

Relationship between two tables based off multiple columns?

Hi all,   Hoping someone can help me with this one as it's really got me stuck.   Basically I have four tables. One table is a Cost Centre hierarchy, with high level codes feeding into lower leve...
Need Help
tamerj1's avatar
tamerj1
Community Champion
3 years ago

aid928 
I mean something like this

You vcan use power query or dax to create a unique table and use it as a bridge table. Would this make sense to you?

aid928's avatar
aid928
Helper I
3 years ago

Ah apologies again, I had the relationship going to the wrong field. Have got it working, thank you so much!