Data Modelling

[tsarun1992]

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 !!

[Gianluca88]

Hi @tsarun1992 ,

have you already tried with Power Query Editor? 

Let me know.

G. 

[Gianluca88 · Accepted solution]

@tsarun1992 

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. 

[tsarun1992]

Trying it, it's processing !!

Let me share the results soon 🙂

[Gianluca88]

Thanks @tsarun1992 , everything works as you like?

g.