Append records where does not exist on first query

[Anonymous]

Hi,

I have two queries from different sources, I would like to add to the first query from second query where records does not exists on first record.

Table 1

Col1       Col2       Measure

100         XYX       30

234         ZZ           40

Table 2

Col1

200

100

Desired outcome

Col1       Col2       Measure

100         XYX       30

234         ZZ           40

200

can you hep?

Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

One sample for your reference, please check the following steps as below.

1. Create a calculated table and make it related to the table1.

Table = 
VAR a =
    CALCULATETABLE (
        VALUES ( Table1[co1] ),
        FILTER ( Table1, Table1[co1] <> BLANK () )
    )
VAR b =
    CALCULATETABLE (
        VALUES ( Table2[co1] ),
        FILTER ( Table2, Table2[co1] <> BLANK () )
    )
RETURN
    DISTINCT ( UNION ( a, b ) )

2. After that, we can get the excepted result. Please note here we should enable the option show items with no data.

[Anonymous]

Hi,

I have two queries from different sources, I would like to add to the first query from second query where records does not exists on first record.

Table 1

Col1       Col2       Measure

100         XYX       30

234         ZZ           40

Table 2

Col1

200

100

Desired outcome

Col1       Col2       Measure

100         XYX       30

234         ZZ           40

200

can you hep?

Thanks