M code in Power query Custom Column created not consistent

[Anonymous]

Hi All

This one is doing my head in. 

Custom Column 1 -> I created a Custom Column in Power Query Editor where the "SupplierCode" from another table (DimmSupplier for Lookup-EDI) is looked up and added into the table where the SupplierCode = SupplierID.  Works just fine

Custom Column 2 ->So now I want to do the same between two other tables and  I get the "Token Equal expected" error message.

I know it is going to be something silly, but I just cannot figure it out.

Any help or another way of doing it will be appreciated.

[wdx223_Daniel · Accepted solution]

@Anonymous  variant name can not include space, if you do need a space in the name ,try to bracket it in #"", such as #"Var Name"

[Anonymous]

Awesome!! You are DA MAN DAN!! Working just fine now.