Replace values from column1 to another using dax

Hi refint650 ,

Hope all is going well.

Please follow these steps:

1. This is the original data I created:

2. To achieve your needs, I created two calculated columns, the DAX syntax is as follows:

Calculated Dept =
IF('Table1'[Prior Dept] = blank() || [Prior Dept] = "unmapped",'Table1'[Emp Dept],'Table1'[Prior Dept])

Calculated Role=
IF('Table1'[Prior Role] = blank() || [Prior Role] = "unmapped",'Table1'[Emp Role],'Table1'[Prior Role])

3. Drag them to the report page for display. The effect is as follows:

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!