Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Nested IF OR statement in Power Query

Hi,   Just wondering if someone could help with an error I'm getting from my Power Query IF / OR statement below which I am using to get times into a time bucket within a Custom Column.   I keep ...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    Your greater signs and equal signs are not in the correct position, and you did not add double quotes to the fields after Then function.

    So you can refer this following formula,

     

    if [#"ReceievedDate - Time"] >= #time (0,0,0) or 
[#"ReceievedDate - Time"] < #time  (1,0,0) 
then "00:00 - 01:00"

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dhreorg's avatar
dhreorg
Frequent Visitor
6 years ago

Hi, I was looking to get help with an IF statement error that I'm getting with creating a new calculated column

if ([Sales Amount] > 0 and [Product] = "Product 1" or [Product] = "Product 2" or [Product] = "Product 3"),1,0)

 

I'm essentially trying to create multiple columns, where I can group various products together into packages, under specific parameteres.

 

but I keep getting an error;

Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

 

Would appreciate any advice on this.

parry2k's avatar
parry2k
Super User
6 years ago

dhreorg try this

 

if [Sales Amount] > 0 and ([Product] = "Product 1" or [Product] = "Product 2" or [Product] = "Product 3") then 1 else 0

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

  • dhreorg's avatar
    dhreorg
    Frequent Visitor
    6 years ago

    parry2k  thank you, that worked perfect!