Forum Discussion
&&& seperator
Hi all,
When writing a formula like concatenate with more than 3 pieces text, I am forced to use the && seperator.
However the && seperator does not work somehow...
Also I would like to know how to change the ; seperator to a komma, I believe these are Dutch setting to powerbi that I don't know how to change to american standards.
Thank you
3 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous,
Based on my test, the "Concatenate" function can only accept two two parameters. Reference:https://msdn.microsoft.com/en-us/query-bi/dax/concatenate-function-dax
If you want to concatenate multiple characters, you could nesting the function like:
New Calculated Column = CONCATENATE( CONCATENATE( CONCATENATE([Column1],[Column2]),[Column3]),[Column4])Regards,
Daniel He
- v-danhe-msft
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He