Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |