Forum Discussion

bkirkey's avatar
bkirkey
New Member
9 years ago
Solved

Multi Variable N:N Relationships?

Hey all,   I am a little stumped on a task I've been asked to do. I have two tables that have three identical variables I need to compare against each other: budget vs spend.   The variables in e...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi bkirkey,

     

    Create a table with distinct type value from those tables, then create relationship with 'both' cross filter direction.

     

    Link Table = DISTINCT(UNION(VALUES(Sheet2[Type]),VALUES(Sheet3[ Type])))

     

    Reuslt:

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

HI bkirkey,

 

Please provide more detailed information to help us clearly know your scenario.

BTW, current power bi not support to direct create M:M relationship, you should add a bridge table to link them and convert to M:1 relationship.

After above steps, if you want to use both side data in one visual at same time, you should summary one side, otherwise it will get error.

 

Regards,

Xiaoxin Sheng