If Then Else with AND operator (acting as a BETWEEN)
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]