Power查询条件列-合并1行/输出的2个值

Question

条件列的1行/输出可以组合2个值吗？下面是一个例子。

目前，2个项目：

each if 
[source] = "Source" and [medium] = "Medium" and [medium-2] = "Paid Search" 
or [source] = "Source" and [medium] = "Medium" and [medium-2] = "cpc"
then ="Paid Search"

期望，1行-将“media-2”的两个值合并成一行：

each if
[source] = "Source" and [medium] = "Medium" and [medium-2] = "Paid Search" or "cpc"
then ="Paid Search"

谢谢你的帮助，斯科特

Answer 1

逻辑上，

([source] = "Source" and [medium] = "Medium" and [medium-2] = "Paid Search") or
([source] = "Source" and [medium] = "Medium" and [medium-2] = "cpc")

等于

[source] = "Source" and [medium] = "Medium" and
( [medium-2] = "Paid Search" or [medium-2] = "cpc" )

也就是说。

( A && B && C ) || ( A && B && D ) = ( A && B ) && ( C || D )

如果这个问题与语法有关，那么我要指出的是

[medium-2] = "Paid Search" or [medium-2] = "cpc"

可以重写为

List.Contains( { "Paid Search", "cpc" }, [medium-2] )

除非你有两个以上的选择，否则它不会短得多。