Forum Discussion

JDBOS's avatar
JDBOS
Icon for Helper III rankHelper III
6 years ago
Solved

For formulas, how does Power BI interpret a Slash in a character string - entered versus pasted?

As I built this question, I seemed to have found a bit of an answer but would appreciate your coaching re why this works...   In constructing an "If" statement, I copied and pasted the logical test...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    JDBOS , Have copied it from a text editor? Because I tried /end/ and D/AS/N and it worked for me.

     

    In case you took from some editor which taken /N as enter or some other formatting there. I might have carried that to power bi, hence the error

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi JDBOS ,

     

    We restore your issue, 

     

     

    It is worth noting that this error occurs only when we use the wrong double quotes.

    So please use the straight double quotes, the text in the straight double quotes will be red and it will work fine.

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

JDBOS , Have copied it from a text editor? Because I tried /end/ and D/AS/N and it worked for me.

 

In case you took from some editor which taken /N as enter or some other formatting there. I might have carried that to power bi, hence the error

  • JDBOS's avatar
    JDBOS
    Icon for Helper III rankHelper III
    6 years ago

    amitchandak I'll do some experimenting - these autism diagnosis combinations were drawn from several sources and pasted into an email, then copied into an Excel spreadsheet so plenty of places for special characters to have been picked up...