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

  • NAOS's avatar
    NAOS
    Advocate III
    7 years ago

    Hi Xiaoxin,

    That's what I ended up doing. Thanks for your answer!