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

MontanaBlack's avatar
MontanaBlack
New Member
2 years ago

Hi everyone, 

 

I have the same issue but actually don't understand what's wrong with my code. I get the error message: missing identifier". Hope someone can help. The code is:

let
//Find the current date and time when this query runs
CurrentDateTime = DateTimeZone.FixedUtcNow(),
//Find yesterday's date
PreviousDay = Date.AddDays(DateTime.Date(CurrentDateTime),–1),
//Put the current date and time in a new column in the table
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "UTC", each CurrentDateTime),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"UTC", type datetimezone}}),
//Add the filter required for incremental refresh
//Only return rows in this table if:
//a) The RangeStart parameter equals yesterday's date, and
//b) RangeEnd is not null (which should never be true)
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each DateTime.Date(RangeStart)=PreviousDay and RangeEnd<>null)
in
#"Filtered Rows"

 

  • Rudz's avatar
    Rudz
    Kudo Collector
    2 years ago

    "–1" is the problem. This is "en dash" 1 not "minus one". Retype the minus.