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       Mea...
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.

     

     

     

     

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity 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.