Forum Discussion

NAOS's avatar
NAOS
Advocate III
7 years ago
Solved

power query expression.syntax error invalid identifier with parentheses

Hi all, I'm trying to reference a column in a query step as follows: ModifySiteArea = Table.ReplaceValue(RenameColumns,each [Site Area (m2)], each if [UnitOfMeasurement] = "ft²"  then Value.Divide([...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI NAOS,

     

    Actually, current you can't use specific characters in [] operator. Maybe you can consider to change name before do this operation and restore fields name after finished replace operations.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Rudz, this worked for me!

I was getting the error due to my column names beginning with "(ref)." and this saved me from having to add multiple unnecessary steps

 

 

Before:

 

 

		if [(ref).v_cust_po_date] = null
		then [(ref).so_header_create_date]
		else [(ref).v_cust_po_date]),

 

 

⚠️ Invalid identifier.

--

After:

 

 

		if [#"(ref).v_cust_po_date"] = null
		then [#"(ref).so_header_create_date"]
		else [#"(ref).v_cust_po_date"]),

 

 

✔️ No syntax errors have been detected.

 

thomasfmeier's avatar
thomasfmeier
Frequent Visitor
1 year ago

Thank you for this. Had the same issue with a field [Total Price Ex Tax ($)] and your solution solved this 🙂