Need Help in Comparing the two columns in same table

[KeerthanaSK86]

Hi,

I have a dataset with EmployeeID, DepartmentID and Manager name and Manager ID. For the employees with department number 100, I need to check their corresponding Manager's Department ID and replace the employee's ID. This worked in SQL server but how to implement this power BI. T 

[Dinesh_Suranga]

@KeerthanaSK86 ,

Hi

Could you please share smome sample data in current view and expected result?

Thank you