https://community.fabric.microsoft.com/t5/Developer/Dax-advanced-union-type-operation/m-p/665709#M19050 Hi,<BR />I am wondering if it is possible to perform a dax operation that does some sort of union of two tables and takes all the records from table1 but only takes the records from table 2 that dont have a matching KeyField value in table 1<BR /><BR />E.g<BR /><BR />Table 1<BR />KeyField1, value<BR />1 , London<BR />2, Paris<BR />3, Germany<BR /><BR />Table 2<BR />KeyField1, value<BR />1, Sydney<BR />4, New york<BR /><BR />Unioned table<BR />KeyField1, value<BR />1 , London<BR />2, Paris<BR />3, Germany<BR />4, New york<BR /><BR />The record for Sydney is not included in the result because table 1 already has a record with the same key value of 1.<BR /><BR /><BR />Thanks<BR /><BR />James Tue, 09 Apr 2019 17:46:28 GMT JamesJack 2019-04-09T17:46:28Z https://community.fabric.microsoft.com/t5/Developer/Dax-advanced-union-type-operation/m-p/665709#M19050 Hi,<BR />I am wondering if it is possible to perform a dax operation that does some sort of union of two tables and takes all the records from table1 but only takes the records from table 2 that dont have a matching KeyField value in table 1<BR /><BR />E.g<BR /><BR />Table 1<BR />KeyField1, value<BR />1 , London<BR />2, Paris<BR />3, Germany<BR /><BR />Table 2<BR />KeyField1, value<BR />1, Sydney<BR />4, New york<BR /><BR />Unioned table<BR />KeyField1, value<BR />1 , London<BR />2, Paris<BR />3, Germany<BR />4, New york<BR /><BR />The record for Sydney is not included in the result because table 1 already has a record with the same key value of 1.<BR /><BR /><BR />Thanks<BR /><BR />James Tue, 09 Apr 2019 17:46:28 GMT https://community.fabric.microsoft.com/t5/Developer/Dax-advanced-union-type-operation/m-p/665709#M19050 JamesJack 2019-04-09T17:46:28Z