Can any one help me here. I am trying to convert a calculated column in spotfire to power bi. But unable to find a dax equivalent for this.
- Spotfire expression -
If((case when (UniqueConcatenate(Concatenate("'",[productgroup],"'"))over [customer]) ~= '${Product2}'
then [customer] end)
=
(case when (UniqueConcatenate(Concatenate("'",[productgroup],"'")) over [customer]) ~= '${Product1}'
then '' else [customer] end),[cutomer],NULL)
couldn't find a unique concatenate equivalent in power bi. Tried with concatenate(distinct) , but it returns an error.
Thanks in advance