topic Re: DAX syntax highlighting in Notepad++ in Developer

DAX syntax highlighting in Notepad++

skasper — Thu, 22 Feb 2018 13:33:12 GMT

Hi,

ever since my DAX statements got more advanced, I found the code window in Power BI Desktop too small and wanted to use Notepad++ for it. Alas, there is no pre-defined syntax highlighting for DAX. So I went ahead and created my own. I share instruction on how to do that and also the already prepared XML file for easy import into Notepad++ over here: www.sascha-kasper.com/dax-syntax-highlighting-for-notepad/

You can have DAX syntax highlighing inside Notepad++ within 1 minute after reading this.

I hope it helps you as it helps me.

Re: DAX syntax highlighting in Notepad++

Greg_Deckler — Thu, 22 Feb 2018 14:21:39 GMT

This is great. The only issue that I had is that every time I click on Styler in the 64-bit version of Notepad++ it errors out, but that's not your issue! Thanks for putting this together!! The import worked awesome, that's definitely the way to go!!

Re: DAX syntax highlighting in Notepad++

skasper — Fri, 23 Feb 2018 08:51:00 GMT

Thank you. I am glad you find it useful.

I am currently working on auto-complete, but this seems a bit buggy.

Re: DAX syntax highlighting in Notepad++

skasper — Fri, 27 Apr 2018 12:19:24 GMT

Hi again,

I updated the DAX.xml file for Notepad++. It now also offers AutoComplete.

Just download it again and replace the old one.

Make sure you use the latest version (2.05) by checking the comment inside the file.

Let me know, if it works.

Re: DAX syntax highlighting in Notepad++

skasper — Wed, 09 May 2018 06:59:56 GMT

Updated the file (now version 3.01) to include

Parameters
Return Value
Description

See the screenshots in the updated post for details.

I did only preliminary testing, so if you find any issues, please let me know.

Re: DAX syntax highlighting in Notepad++

zapppsr — Thu, 07 Jun 2018 11:55:08 GMT

I tried the step by step screenshots, but I guess it skips to a part where you should have loaded the XML file and doesn't show how to do it. Only at the end of the post it says how to import.

Somehow, I imported but the functions don't appear in the supposed box.

What am I doing wrong?

I'm using Notepad++ 7.5.6 64-bits

Re: DAX syntax highlighting in Notepad++

skasper — Thu, 07 Jun 2018 12:51:28 GMT

Hi @zapppsr,

thank you for pointing this out. I just updated the blog post to include a screenshot showing the 3 clicks for importing the XML file (I am using the same Notepad++ version as you).

I also double-checked the file and after importing it, highlighting and auto-complete work as they should. If you keep experiencing issues, please check the Notepad++ Wiki (http://docs.notepad-plus-plus.org/index.php/Main_Page).

Re: DAX syntax highlighting in Notepad++

skasper — Thu, 07 Jun 2018 12:52:51 GMT

Thank you @Greg_Deckler. Much appreciated. Glad it helps.

Re: DAX syntax highlighting in Notepad++

zapppsr — Thu, 07 Jun 2018 14:04:20 GMT

Hi @skasper,

Thanks for replying and updating the post so quickly.

Maybe because I'm new to Notepad++ I missed the step where I should select the DAX language after Importing it.

Your new screen is good, but I would highlight for noobs like me that I have to select the language after importing...

Other than that, thanks a lot for providing this!

Re: DAX syntax highlighting in Notepad++

skasper — Thu, 07 Jun 2018 14:30:57 GMT

true. I added a sentence or two to explain this, too. Enjoy!

Re: DAX syntax highlighting in Notepad++

zapppsr — Thu, 07 Jun 2018 14:33:25 GMT

Thanks!

Re: DAX syntax highlighting in Notepad++

skasper — Thu, 06 Dec 2018 13:35:02 GMT

Updated the xml file for Notepad++ with the latest DAX functions, giving you syntax highlighting and auto complete.

Find the file and instructions here.

ISINSCOPE
COMBINEVALUES
UTCNOW
UTCTODAY
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T

Re: DAX syntax highlighting in Notepad++

skasper — Mon, 21 Jan 2019 13:13:20 GMT

Hi,

updated the file again with new functions (see change log on the web site).

Also, I did the same exercise for M (Power Query). You can find that here.

I hope they help you.

Re: DAX syntax highlighting in Notepad++

zenton — Sun, 24 Mar 2019 21:41:42 GMT

Hi I am getting a Failed to Import Error for the DAX.xml

Thanks Rodney

Re: DAX syntax highlighting in Notepad++

skasper — Mon, 25 Mar 2019 07:54:01 GMT

Hi Rodney,

I fixed the import file (had forgotten to close a tag). It is working now as it should. Sorry for the inconvenicence. Please find the udpdated file online at the link provided in my post.

Re: DAX syntax highlighting in Notepad++

ctrip77 — Fri, 24 May 2019 07:14:53 GMT

Hi, Im trying the DAX highlihting file, works perfect, but I cant make the autocomplete work, is there something to do to enable this functionality?

thanks @skasper !

Re: DAX syntax highlighting in Notepad++

Rygaard — Wed, 23 Mar 2022 12:13:09 GMT

Thank you !

Re: DAX syntax highlighting in Notepad++

diegomsg — Wed, 03 Aug 2022 12:53:14 GMT

Just downloaded version 4.00. Great improvementes for dark mode. Now I don't need to tweak it anymore. Great job.

Re: DAX syntax highlighting in Notepad++

Anonymous — Fri, 03 Feb 2023 12:05:16 GMT

Hi @skasper ,

Thanks for the xml and blog - realy hepful!

I'm new to Notepad++ sorry, but I was wondering how to parse/format the code so that it steps/indents nicely. Is that possible?

Cheers,

Craig

Re: DAX syntax highlighting in Notepad++

j1s — Wed, 03 Apr 2024 12:17:45 GMT

So @skasper - just checking: we need to pay you for these, and give you email addresses right?