If Then Else with AND operator (acting as a BETWEEN)

[TheBishopEmpire]

I'm in Power Query editor. I've created a new Customer Column called "EmploymentDuration_Days". This field returns the number of days the employee was employed with the company. I'm trying to evaluate the days into something more common for the user. For instance...

if [EmploymentDuration_Days] >= 181 and [EmpoloymentDuration_Days] < 365 then "6 Months-1 Year" else "Some Other Text Here"

...ultimately this will be 7 itterations of the if() but need to understand why the example above returns the error below:

Expression.Error: The field 'EmpoloymentDuration_Days' of the record wasn't found.
Details:
HiredDate=9/6/2001 12:00:00 AM
RetiredDate=7/9/2002 12:00:00 AM
EmploymentDuration_Days=306
EmploymentDuration=[Error]

[edhans · Accepted solution]

I'd have to see your full M code and example, but your error copied has EmploymentDuration_Days mispelled. It might be as simple as that.

'EmpoloymentDuration_Days'

[TheBishopEmpire]

That was merely a typo and I'm truly thankful for your eagle-eye. The spelling error corrected my error.  

[edhans]

Great! My first go-to issue is typos or something not the same case. Employment_Days will not match Employment_days for example and throw the same error.