Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Speed up a List.Contains process

let Source = Excel.Workbook(File.Contents("abc.xlsx"), null, true), FTEDATA_DefinedName = Source{[Item="FTEDATA",Kind="DefinedName"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(FTEDATA_Defi...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , try like this

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if List.Contains(#"Changed Type"[EMPNO],[REPORTING_OFFICER_ID]) then 1 else 0)