cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheBishopEmpire
Frequent Visitor

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]

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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'



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

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'



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors