The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
User | Count |
---|---|
65 | |
62 | |
59 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
47 | |
44 |