Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |