Hi @LearnerBeta
let
Source = Table.FromRecords(
{
[Emp=1, Manager=6], [Emp=2, Manager=7], [Emp=3, Manager=1],
[Emp=4, Manager=8], [Emp=5, Manager=3], [Emp=6, Manager=1]
},
type table[Emp=Int64.Type, Manager=Int64.Type]
),
EmpList = List.Buffer(Source[Emp]),
Type = Table.AddColumn(Source, "Type", each
if List.Contains(EmpList, [Manager])
then "Manager"
else "Individual Contributor",
type text
)
in
Type
If this solves your problem please mark this reply as answer to help others with a similar issue. Thanks in advance Any question please let me know + Nice day...