Forum Discussion
Pasting code back into Power Query, double quotation marks not pasting properly
If you want to write your code with another program, use notepad or Visual Studio Code with M Language installed (intelliSense included!):
So because I made the changes in Word, when I paste the code into there I still run into the same issue. Here's what I'm seeing in the Advanced Editor. I can manually replace them, but we're talking tens of thousands at least haha. I should have provided a screenshot in the original post, sorry about that.
If you want to write your code with another program, use notepad or Visual Studio Code with M Language installed (intelliSense included!):
Definitely downloading now for future use. Thank you!
You're welcome. Enjoy 😉
Thank you again everyone for your help! Sorry for closing this out late, but what I wound up doing to get around this is downloading Visual Studio Code as dufoq3 mentioned then, maybe because it had the familiar color coding, had a much easier time finding and replacing the 'incorrect' quotations with the ones necessary for the Advanced Editor/DAX. I'll definitely be using that program in the future!