Forum Discussion

gcoyle97's avatar
gcoyle97
Frequent Visitor
1 year ago

Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly

Hi All, can someone help with the error I'm having on Power BI query in the subject. I have looked at similar errors but none seem to work for me.   =IF((NETWORKDAYS([PromisedDeliveryDate],[Ship D...
Need Help
m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident Rockstar
1 year ago

Hi gcoyle97,

 

yes I missed a parenthesis, try this:
if (fnNETWORKDAYS([PromisedDeliveryDate], [Ship Date]) < 1) then
Text.From(Number.Abs((fnNETWORKDAYS([PromisedDeliveryDate], [Ship Date]) + 1))) & " Day(s) Faster then Promised"
else if (fnNETWORKDAYS([PromisedDelivryDate], [Ship Date]) < 1) then
Text.From(Number.Abs((fnNETWORKDAYS([PromisedDeliveryDate], [Ship Date]) - 1))) & " Day(s) Late"
else
"On Time"

gcoyle97's avatar
gcoyle97
Frequent Visitor
1 year ago

Thanks m_dekorte this give me no syntax errors.

 

But I know have errors in all my cells.

 

I think this is maybe something to do with the fnNETWORKDAYS query I created?

 

 

  • m_dekorte's avatar
    m_dekorte
    Icon for Resident Rockstar rankResident Rockstar
    1 year ago

    Did you open the Advanced Editor and replaced its contents with the code for the Custom Function that was shared? It looks like a string, you may have copied it into the formula bar instead...

Related content