Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

M code in Power query Custom Column created not consistent

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.

 

DeonDP_0-1603857928049.png

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

@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"

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

@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
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors
Top Kudoed Authors