Forum Discussion
Store DAX snippets
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.
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
2 Replies
- BA_Pete
Super User
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
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.
