Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
for example in the screenshot, I want to make a New Table that I can filter column2 that only shows C and E since they do not have a corrspnding value in Table2
Solved! Go to Solution.
Hi @bwang2
I've created two tables using your data:
Transform data > Home > Merge Queries
Create a table visual, the result is as follow:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bwang2
I've created two tables using your data:
Transform data > Home > Merge Queries
Create a table visual, the result is as follow:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-zhengdxu-msft thank you for re-writing my solution 🤔
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @bwang2
You can achieve this in Power Query.
In Power Query, you can click on Merge then select "Merge as New".
Once you have the new table, you can filter out null values that don't correspond to another value in Table1[Column1].
All the best.
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |