How to add double quote in Calculate?

[Zack92]

Hello 

I have a formula with a double-quote. Please let me know how to fix it. 

Overall, how would you rate your learning experience with "Intro to LogRhythm: What is a SIEM"? = CALCULATE(MAX(CBTSurvey[Answers]), FILTER(CBTSurvey, CBTSurvey[df_Typeform_Summary.title] = "=""Overall, how would you rate your learning experience with "Intro to LogRhythm: What is a SIEM"?""}

Thank you 

[Anonymous · Accepted solution]

Hi @Zack92 ,

If you want to quote text that contains double quotes, you need two sets of quotes. For example,

Best Regards,

Stephen Tao

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

[amitchandak]

@Zack92 , Try \" for double quote in a string

Overall, how would you rate your learning experience with =Intro to LogRhythm: What is a SIEM ? = CALCULATE(MAX(CBTSurvey[Answers]), FILTER(CBTSurvey, CBTSurvey[df_Typeform_Summary.title] = "=\"\"Overall, how would you rate your learning experience with \"Intro to LogRhythm: What is a SIEM\"?\""))

[Zack92]

Hello @amitchandak ,

Thank you for the quick response, I tired your dax, but getting below error

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 97, \.

Any idea why is that? 

Thank you