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,
I have two different tables. Table A & B.
Table A has Employee Name & S No.
Table B has Employee Name & their corresponding CRM number.
Query : In Power BI, I need to create a new table automatically using DAX, with the list of employees name who dont have a CRM number.
It might be a simple solution but its not striking my mind 😄
Help needed !!
Solved! Go to Solution.
In Power Query you can simply that this job with the "merge queries" option and you have to choose the two tables involved and then use the option "Left Anti (rows only in first).
Please check and let me know.
If you are satisfied with this option, please mark it as solution to help other users to find quickly the solution to your answer.
In Power Query you can simply that this job with the "merge queries" option and you have to choose the two tables involved and then use the option "Left Anti (rows only in first).
Please check and let me know.
If you are satisfied with this option, please mark it as solution to help other users to find quickly the solution to your answer.
Trying it, it's processing !!
Let me share the results soon 🙂
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |