Forum Discussion
Solved
if else condition with between operator
Hi, I am using M language and adding a new column in table. I need to write if condition in this line. I am writing if condition like this: if [Month] between 2 and 4 then "yes" else "no" Now...
Hi
You can do this
if [Month] >= 2 and [Month] <= 4 then "yes" else "no"
/Erik
v-sihou-msft
Microsoft Employee
Microsoft Employee
In Power Query, there's no "between" keyword, you can only use operators to achieve this kind of logic as donsvensen suggested.
See: https://msdn.microsoft.com/en-us/library/mt186365.aspx
Regards,
Hi Simon, Thanks for your suggestion. Yes that way it is working. Thanks all for your time and suggestions.