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

[kfschaefer]

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

[Korryk]

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

[kfschaefer]

[Anonymous]

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#

[Sean]

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

[kfschaefer]

How should I modify the if then else statement to include another layer:

if(hasonevalue([Term Date]),"Termed" if([#"#YearsofService"]>=2) then "2 + Years" else "Less Than 2 Years")

Could you help with the syntax?

Karen

[ImkeF]

try this:

= Table.AddColumn(#"Reordered Columns2", "YearsofSvce", each if [YrofSvc] < 2 then 1 else 2)

[ImkeF · Accepted solution]

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

[kfschaefer]

Thanks for all the great input.

K

[ImkeF]

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

[Sean]

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

[Sean]

Post a screenshot...