谁能帮我一下吗?我在试着将spotfire中的计算列转换为power bi。但无法找到与此相同的dax。
- Spotfire表达式-
If((case when (UniqueConcatenate(Concatenate("'",[productgroup],"'"))over [customer]) ~= '${Product2}'
then [customer] end)
=
(当(UniqueConcatenate(Concatenate("'",[productgroup],"'")) over [customer]时)~= '${Product1}'then " else [customer] end),[customer],NULL)
在幂bi中找不到唯一的等价连接。尝试使用concatenate(distinct),但返回错误。
Thanks in advance
IF (计算((表名[productgroup]),FILTER (ALL (TableName[customer]), TableName[customer] = early (TableName[customer]))(= 1,,CONCATENATEX (VALUES (TableName[productgroup]), TableName[productgroup], ", ")& lt;比;"$ {Product2}",,CONCATENATEX (VALUES (TableName[productgroup]), TableName[productgroup], ", ")& lt;比;"$ {Product1}",表名(客户),空白())