Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I can't solve this problem, due to I don't know where to exactly start and need to have this 100% correct.
So basicaly I have 2 tables (same format), both contains this columns: date; perosnal ID
Table A contains more ppl.
Table B contains ppl which i do not want in my new table.
I need to create Table C, where are just ppl from Table A which are not in Table B.
I also need to respect date, because some ppl (cca 10) came twice or three times.
Table C contains: date; personal ID (in A not in B).
Thank you for help 🙂
Solved! Go to Solution.
You have to do a Lef anti join in Power Query. Check this example: https://learn.microsoft.com/en-us/power-query/merge-queries-left-anti
You have to do a Lef anti join in Power Query. Check this example: https://learn.microsoft.com/en-us/power-query/merge-queries-left-anti