Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Append records where does not exist on first query

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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.

     

     

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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.