Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |