Compare 2 column to one

[Anonymous]

Hello!

I'm try to understand how can i make from 2 colums in different tables a new table with all distinct data from 2 column?

Now i'm thy to make a directory for addresses that are referenced by 2 caves. Naturally, I wanted to load different values. I tried to use variables, but only for one field.

If anyone becomes more intelligible, then I would like to perform the same function as in Qlik:

concatinate(Table)

load

distinct

...

But i'm cant understend how do that....

Best regards, Anton

 

[Anonymous]

Hello!

It ok, all work. But the names table not in english most have a single quotes for its work...

[v-frfei-msft]

Hi @Anonymous,

One sample for your reference. We can new a calculated table using the formula.

Table = DISTINCT(UNION(VALUES(Table1[name1]),VALUES(Table2[name2])))

For more details, please check the pbix as attached.

Regards,

Frank

[Greg_Deckler · Accepted solution]

So this is a wild guess because I only caught about half of that. So, first the new Composite model feature supports many-to-many relationships. It's in preview but that is one option. But, if you need a table of DISTINCT values in order to bridge the two tables, you could do this:

Table = DISTINCT('Table'[Column])

Now, if you need a table that has all of the distinct values from both tables, then:

Table = DISTINCT(UNION(VALUES(Table1[Column1]),VALUES(Table2[Column1])))