adding (only the not-yet-existed) values from other table

[RMV]

Hi,

I have a table, called Table 1, that listed a number of location. for example,

Table 1

Location Name

-----------------

Location A

Location B

Location C

Then there's another table, called Table B, that has another locations, for example

Table 2

Location Name

-----------------

Location A

Location C

Location D

Location E

I would like to add the location names that are available in Table 2, but not available in Table 1 using dax, to be added in Table 1, without creating a new table to merge both table. Since, I already have a complete measurements I need in Table 1, and just realized that there's some other locations are not included.

Thus, the result I expect in Table 1 is

Location Name

-----------------

Location A

Location B

Location C

Location D

Location E

How can I do this in dax?

[Mariusz · Accepted solution]

Hi @RMV 

I know you asked for DAX solution but, you can use Append Queries ( on table 1 ) in Query Editor and use Group by after to get unique Location Names.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[RMV]

Hi @Mariusz ,

Thanks for the suggestion.

yea, I would like to use dax, since there are numbers of tables in the file, and I'm afraid adding a query affected the refresh performance.

Well, I think I need to give it a try.

Thanks a lot, again.