Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

&&& 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

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello Anonymous

     

    For concatenate you only have to use one "&" the "&& is the form use for AND", and for the change of the list separetor you can change them from the configuration of "Regional settings"

     

    I hope this was helpful.

     

    Good luck.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello Anonymous

     

    For concatenate you only have to use one "&" the "&& is the form use for AND", and for the change of the list separetor you can change them from the configuration of "Regional settings"

     

    I hope this was helpful.

     

    Good luck.

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    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