Hi I need to manage a relationship with two tables Table 1 RegionSpendASEC54555EMEAI64363EMEAI45455ASEC5554AMER2254ASEC2244AMER55558 Table 2 RegionSavingsEMEAI500ASEC250ASEC200AMER150EMEAI100AMER444 Result: RegionSpendSavingsAMER57812594ASEC62353450EMEAI109818600Total2299831644 Visual shall be Please help minimum on how to relate these two tables

Helper II

8 years ago

Solved

Manage Relationship between two tables without unique values

I need to manage a relationship with two tables

Table 1

Table 2

Result:

Visual shall be

Please help minimum on how to relate these two tables

RolandsP
Resolver IV
8 years ago
You need to create a Bridge table with only one column that contains unique Region values. Then you can link Table1 and Table2 through the Bridge table.

Microsoft Employee

You need to create a bridge table named as 'Table3'.

Table3 =
UNION (
    VALUES ( Table1[Region] ),
    EXCEPT ( VALUES ( Table2[Region] ), VALUES ( Table1[Region] ) )
)

Create a one-to-many relationship from 'Table3' to 'Table1' and 'Table2'.

Then, drag 'Table3'[Region] and 'Table1'[Spend] and 'Table2'[Savings] to visual.

Best regards,

Yuliana Gu

Helper II

What if I have multiple colums and want to create relationship between table 1 & table 2.

Do I have to create bridge table for all columns separately to pull savigs & spend with respect to Region, Country or Entity?

Table 1

Table 2

mahra-in
Helper II
8 years ago
Is there a way to remove blank or null rows in the bridge table