Union tables when one column only exists in one of the tables

[aashton]

 How do you go about union-ing tables together when you want to include a column that only exists in one of the tables?  For example, I want to include the ID, Name and Phone from each table (there are many more fields I am not picking so I am using SUMMARIZE), and email which only exists in Table C.

TAble A

ID, Name, Phone

TAble B

ID, Name, Phone

Table C

ID, Name, Phone, Email

[v-yanjiang-msft · Accepted solution]

Hi @aashton ,

According to your description, here's my solution.

Sample:

TableA:

TableB:

TableC:

Create a new table:

Table =
UNION (
    SELECTCOLUMNS (
        'TableA',
        "ID", 'TableA'[ID],
        "Name", 'TableA'[Name],
        "Phone", 'TableA'[Phone],
        "Email", BLANK ()
    ),
    SELECTCOLUMNS (
        'TableB',
        "ID", 'TableB'[ID],
        "Name", 'TableB'[Name],
        "Phone", 'TableB'[Phone],
        "Email", BLANK ()
    ),
    SELECTCOLUMNS (
        'TableC',
        "ID", 'TableC'[ID],
        "Name", 'TableC'[Name],
        "Phone", 'TableC'[Phone],
        "Email", 'TableC'[Email]
    )
)

Get the correct result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Idrissshatila]

Hello @aashton ,

you could append all these tables in Power query and the email values will show only for the values in table C while the others will show null.

https://zebrabi.com/advanced-guide/how-to-append-data-in-power-bi/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin