Forum Discussion
efstel
Helper I
Helper IConditional Column with Multiple Conditions
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 contai...
The response didn't quite answer my question. I figured out a workaround.
ZhangKun
Super User
Super UserYou 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.