Store DAX snippets

[JohnAlex100]

Hello all this is my first post in this community and I am fairly new to PowerQuery as well.

Right now, I am using PowerQuery for data preparation to format various employee lists from various sources. Not all lists need the same preparation and some need more or less. 

However, there are common transformations I make from list to list and I repeatedly reuse snippets of DAX to make the final product I pass on.

Is there anything I can use to easily store these small lines of code? Right now, I have just been using an Excel file which is not ideal.

Thanks.

[BA_Pete · Accepted solution]

Hi @JohnAlex100 ,

I personally use Notepad++ for DAX/M/SQL etc: https://notepad-plus-plus.org/ 

You can download/create/edit formatting definitions for each language, although there are a lot pre-loaded.

Examples:

DAX:

M

SQL

Pete

[JohnAlex100]

That is a great idea! I use Notepad++ daily for other tasks, but I didn't even think to use it store DAX. And my team all uses Notepad++ so if I ever need to share these snippets, it is a software we are very familiar with. Thank you.