Conditional Column with Multiple Conditions

[efstel]

I am adding a conditional column in power query editor and pulling numbers out of a column named Amount. When the value in the Column named GLAcct does not end with ".            " or does not contain ".CORP". And I'm creating another column similarly when the value in the Column named GLAcct ends with ".            " or contains ".CORP". (See screen shots below.)

The problem is that the first conditional column includes values in the Amount column when ".CORP" is contained within the column. 

[v-hashadapu]

Hi @efstel , Happy to know your issue is resolved. Kindly share your insights here and mark them 'Accept as Solution', so others with similar queries may find them easily. Thank you.

[v-hashadapu]

Hi @efstel , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[efstel · Accepted solution]

The response didn't quite answer my question. I figured out a workaround.

[v-hashadapu]

Hi @efstel , We are pleased to hear that you have found a workaround. Kindly let us know if it successfully resolved your issue. If it did, please share the details here and mark it as 'Accept as solution' to assist others with similar problems. If it did not, please provide further details.
Thank you.

[ZhangKun]

You should clarify your judgment rules (modify the judgment rules or adjust the order of creating columns and determine whether the first column has taken the value of the Amount column before creating the second column), because they have overlapping parts.

The Venn diagram below shows your problem, in which the filled squares are the overlapping parts.