Forum Discussion
Show only matching values from multiple tables
Hi all,
I have 2 tables like this :
Table 1
| Ord_Number | Status |
| 10 | D |
| 20 | D |
| 30 | D |
Table 2
| Ord_Number | Status |
| 40 | U |
| 50 | U |
and I have Table 3 have so many numbers including some values from table 1 & 2 like this:
Table 3
| Ord_Number | Status |
| 10 | D |
| 15 | D |
| 20 | D |
| 45 | U |
| 50 | U |
So what i'm trying to do to show all the data who matched in table 1 and 2 like this:
Table 3
| Ord_Number | Status |
| 10 | D |
| 20 | D |
| 50 | U |
Thanks all
Hi Zilver ,
You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.
Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Table 3, the last one is common of 1 and 2. But one and two had nothing common.
But refer
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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 Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on LinkedinSo far what I did is I create table 3 and I put table 1&2 in (filter on this page) and I select filter type : basic filtering "select all" for both table. and ofc I create relationship between them as (many to one)(both).
and didn't work 😞
please if someone could help me how to fix that I really appreciate it.
What is the logic to achieve this table
Table 3
Ord_Number Status 10 D 20 D 50 U
Hi Zilver ,
You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.
Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
