Linking a unique table (that has some Null values)

[CloudMonkey]

Hi,

I need to link 2 tables. The first table has 'many' values and the second table has 'unique' values but also some NULL records which are causing the mapping to fail. Please can you tell me how to map the two tables? (where there is a NULL of course I expect to value to be returned when I use the "Related" formula which is fine)

Thanks,

CM

[CloudMonkey]

I guess what I'm asking for is a left outer join for a table link, without having to merge the tables? is it impossible?

[v-shex-msft]

Hi @CloudMonkey,

If your tables contains the records which can't match other table, it will shows the null value at the new table. You can try to use INTERSECT function to check if they contains the value which can't match.

Records= INTERSECT(VALUES('Table'[Column]),VALUES('Table 2'[Column]))

Regards,

Xiaoxin sheng