I created a new model and brought in the two tables.
So we have the master table and then we need some customer details into this one.
So all I’m going to do is first merge them
Then will bring in all these columns to see what it looks like
This got me to here
I can clean this up a bit
Now I commit this and go to the model and create a calculated column in this table.
Make sure to disable the load of the previous table as well. You don’t need this is your model anymore.
Here’s the simple calculated column
Updated Customer ID =
IF( ISBLANK( 'Customer Master'[Customer Group] ), 'Customer Master'[Master Customer ID], 'Customer Master'[Customer Group] )
That’s it really.
Now you have your normalized column for the ID, and you don’t need that additional table anymore.
(I also realized by working through this getting rid of the ‘nulls’ was uneccassary, so you can skip that part)
See how you go working through this.
Employee ID merge example.pbix (218.2 KB)