Forum Discussion
Solved
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 evaluat...
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'
edhans
Community Champion
Community ChampionI'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'
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.