Need Help in Comparing the two columns in same table

Question

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&nbsp;

dinesh_suranga · Answer

KeerthanaSK86&nbsp;,HiCould you please share smome sample data in current view and expected result?Thank you

Forum Discussion

Need Help in Comparing the two columns in same table

1 Reply

Related content

Table Sort , sort order , comparer

Compare two columns in different tables

Comparing two tables columns by columns

Compare 2 Tables

Compare two columns in a table visual