Forum Discussion
Solved
Create a manager's flag in M-Query
Create a PBI M-query for a 'Yes' or 'No' flags for Is_employee_a manager? I have a table called Employee with column Employee_id, Manager_employee_id and Period. The logic is to identify and ...
You could try something like...
Table.AddColumn(PREVIOUSSTEP, "Flag", each if List.Contains(List.RemoveItems(List.Distinct(Table.SelectRows(PREVIOUSSTEP, (x)=> x[Period] = [Period])[Manager_employee_Id]), {" "}), [Employee_Id]) then "Yes" else "No")
You could try something like...
Table.AddColumn(PREVIOUSSTEP, "Flag", each if List.Contains(List.RemoveItems(List.Distinct(Table.SelectRows(PREVIOUSSTEP, (x)=> x[Period] = [Period])[Manager_employee_Id]), {" "}), [Employee_Id]) then "Yes" else "No")
Thank you.
That solved it.