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

Rudz's avatar
Rudz
Kudo Collector
5 years ago

I had a similar problem with a column with a question mark in the column name. Here's the syntax that worked there. I'm guessing it would work for yours too.

 

[#"Valid?"]

 

KERZ's avatar
KERZ
New Member
4 years ago

worked like a charm