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.
Hi all,
Looking at following dilemma, would appreciate any advice how to achive that.
I have one table which is fetching values from external data source, let's call this table MainTable:
Some ID Number | Some Data | More Data |
1234567 | AAA | 58 |
2345678 | BBB | 78 |
3456789 | CCC | 86 |
7890123 | DDD | 53 |
Then there is another 3 tables which is fetching data from another source and then appends then into 1 joined table CombinedTable , where ID values can match values from MainTable, for example:
Some ID Number | Some Data | More Data |
4567890 | EEE | 90 |
3456789 | CCC | 86 |
5678901 | FFF | 33 |
2345678 | BBB | 78 |
What is easiest and most efficient way to compare values which exist in MainTable to values in CombinedTable and keep them only if they are in MainTable , i.e final result should be:
Some ID Number | Some Data | data |
3456789 | CCC | 86 |
2345678 | BBB | 78 |
So in the nutshell, commom denominator for filtering would be always ID value from MainTable since CombinedTable would always contain signifcatly more values which are not needed.
Thanks a lot for any ideas!
Solved! Go to Solution.
Hi,
You can merge your CombinedTable with MainTable using JoinKind Inner
You obtain this
Then you can remove column MainTable
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
You can merge your CombinedTable with MainTable using JoinKind Inner
You obtain this
Then you can remove column MainTable
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thanks, but it won't make any issues since real tables I have are way more complex and contain a lot of relationships and are merged themselves?
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |