Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago
Solved

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

After numerous hours of researching this issue for 2 days, I am really stumped.

 

I have tried to create a simple function of either If or Switch and both return the above mentioned error.

 

I even created a sample based on the example supplied on MSDN for the IF Function, trying to use it both in the Power BI Desktop and/or Power Query for Excel 2013 (32 bit) environments. Without any luck.

 

I am using the latest download of Power query and PBI,  I just set up my computer in the last week.  Urgently need of help.

 

Thanks,

Kfs

  • ImkeF's avatar
    ImkeF
    10 years ago

    Hi Karen,

    sorry, didn't read your question right. This will be the formula with the added condition:

     

    if [TermDate] <> null then ''Termed" else if ([#"#YearsofService"]>=2) then "2 + Years" else "Less Than 2 Years")

     

    or

     

    if [TermDate] <> "" then ''Termed" else if ([#"#YearsofService"]>=2) then "2 + Years" else "Less Than 2 Years""

11 Replies

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      I think in M you have to use => if .... then ... else...

      • ImkeF's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Exactly as Sean said. And watch out: M is case sensitive!

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      kfschaefer this is an issue with M

       

      to me it looks like you are mixing up DAX and M the way you reference the column???

       

      But ImkeF is the M expert - maybe she can help you???

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi kfschaefer,

       

         is as Sean and ImkeF said. Take a look at this examples:

       

      Excelguru

      Technet

       

      Just remember as ImkeF said that M is very case sensitive so you have to write:   if (. . .) then (. . .) else (. . .)

       

       

      #I'M Not An Expert#

  • Korryk's avatar
    Korryk
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Ok so I'm a little confused can I note formulate like the following?

     

    =IF([SubmitFiscalMonth]="FM-01 (Jul)",1,IF([SubmitFiscalMonth]="FM-02 (Aug)",2,IF([SubmitFiscalMonth]="FM-03 (Sep)",3,IF([SubmitFiscalMonth]="FM-04 (Oct)",4,IF([SubmitFiscalMonth]="FM-05 (Nov)",5,IF([SubmitFiscalMonth]="FM-06 (Dec)",6,IF([SubmitFiscalMonth]="FM-07 (Jan)",7,IF([SubmitFiscalMonth]="FM-08 (Feb)",8,IF([SubmitFiscalMonth]="FM-09 (Mar)",9,IF([SubmitFiscalMonth]="FM-10 (Apr)",10,IF([SubmitFiscalMonth]="FM-11 (May)",11,IF([SubmitFiscalMonth]="FM-12 (Jun)",12,"N/A"))))))))))))