需求:如果列【Opportunity Name】中包含字符“WAI”,则把【Opportunity Owner: Department】中所有其他的值替换为“WAI”
当前的代码:
= Table.ReplaceValue(#"Copy of corp-detail test-luo ji", each Text.Contains([Opportunity Name], "WAI", "WAI", Replacer.ReplaceValue,{"Opportunity Owner: Department"}))
错误的提示:
Expression.Error: 在计算过程中遇到了循环引用