We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register 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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 7 | |
| 5 |