M Query IF statement error

[Anonymous]

Am trying to do the following in m query but am getting an error any help would be great;

if [Product] = "15679" and [Region] = "South" or "North" or "West" then 1 else 0

Error i recieve is the following;

Expression.Error: We cannot convert the value "West" to type Logical. 

[amitchandak]

@Anonymous , Try something like this

if [Product] = "15679" and ([Region] = "South" or [Region] = "North" or [Region] = "West" ) then 1 else 0

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try this

if [Product] = "15679" and ([Region] = "South" or  [Region] =  "North" or  [Region] = "West") then 1 else 0

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.