remove dublicated from 2 diffrent tables and merge it

[qwertzuiop]

Hellor dear Community

I'm quite new to PowerBI.

So let me explain my problem.

I have 2 excel file.

Nr .1 has 50'000 lines

Nr. 2 has 300'000 lines

In both files i work with an TransportID.

But also in both files this transportID can occur several times.

I would like to have a merged table, where i get all transportID that appear in Nr1 + Nr.2 - but the occurence in the merged table should be unique.

Example:

Table Nr. 1:

TranportID
1
2
1
2
3
4
5
…

Table Nr. 2

TransportID
1
1
3
6
6
7
7
…

Merged Table should look like:

TransportID
1
2
3
4
5
6
7

How can I do that?

I would be very thankful for your help

Cheers

qwertzuiop

[amitchandak · Accepted solution]

Try one of the two

distinct(union(all(table1[transport_id]),all(table1[transport_id])))
OR
distinct(union(distinct(table1[transport_id]),distinct(table1[transport_id])))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601