Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Column in Power Query IF ELSE

Is there such a formula in Power Query Custom Column for this:   if ([BUSINESS_UNIT]='ZZZ' and STARTSWITH([ORDER_TYPE],'Standard')) then 'True' elseif ([BUSINESS_UNIT]='ZZZ' and STARTSWITH([ORDER_...
Need Help
  • ERD's avatar
    ERD
    4 years ago

    Anonymous , and using lower case:

    not (...)

ERD's avatar
ERD
Community Champion
4 years ago

Anonymous , try to use brackets near not:

not (...)

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ERD HI

 

still not working

  • ERD's avatar
    ERD
    Community Champion
    4 years ago

    Anonymous , and using lower case:

    not (...)