add row based on missing data

[rtillery2000]

I have to two DB's that I am trying to keep the same reports.
here is the dilemma

Table1 and Table 2 have all the same attributes but Table 2 has one that table 1 doesn't.
This breaks the reporting with "fix this" because the attribute is being relied on.

I am able to pull that value from another table "Table3"
So my goal is:
If Attribute name is missing 'meeting' then add a row with Roomname that is missing it.
Then get value from table3 column 1

Table1:

attributename	roomname	Value
inuse	Room4	0
inuse	Room2	0
inuse	Room1	1
Desktop	Room1	1
inuse	Room3	0

Table 2

attributename	roomname	Value
inuse	Room4	0
inuse	Room2	0
inuse	Room1	1
Desktop	Room1	1
inuse	Room3	0
meeting	Room3	0
meeting	Room1	1

[v-jiascu-msft]

Hi @rtillery2000,

It's hard to add rows. The solution could be creating a calculated table with all the attributes.

Table =
DISTINCT (
    UNION ( VALUES ( Table1[attributename] ), VALUES ( Table2[attributename] ) )
)

Best Regards,

Dale

[rtillery2000 · Accepted solution]

not what I was looking for but it did help get to where I need to resolve the issue.

Thank you.