token ')' expected error, but it makes no sense whatsoever to put a parenthesis there

[Anonymous]

I am going insane. I am trying to copy over a working calculation from one report to another, using the same data. And I cannot get the formula to work. I am creating a custom column and getting an error that says a parenthesis is expected in the middle of my string of text, please help me! See the formula in the attachment and the red squigly underline indicating the ridiculous spot I'm supposed to put ')'

 

[Anonymous]

Thank you it worked perfectly that way. 

[Ahmedx]

pls try this

if [Impact Date] > Date.From( DateTime.LocalNow()) +60 then "ID > 60 Days" 
else if  [Impact Date]  > Date.From( DateTime.LocalNow()) then "lD < 60 Days" 
else if [lmpact Date] = "" then "No Date Provided" else if[Impact Date] <= Date.From( DateTime.LocalNow()) then
"Expired" else null 

[Ahmedx]

what you write is the syntax DAX,
and you need a code in M language

[blopez11 · Accepted solution]

That is a DAX formula that you are trying to use in the Query Editor, which uses the M language.  In the report view, go to the Data pane, right click on the table you wish to add that calculation, and select "New column".  Hopefully that will work for you.