Best DAX code repository for learning

[Riksall]

Hi all,

Which method do you use for storing / learning DAX code? I have 100's DAX formula's, sample PBIX's, youtube links, MS word pages full of code.

But i'm looking for a method to order all these in a searchable and organized repository. Is there any app for this? So not specificaly for DAX but a generic tool? Or some sort of system you have built yourself?

Thanks!

[v-priyankata]

Hi @Riksall ,

Thank you for reaching out to the Microsoft Community Forum.

Here are some approaches and tools that can help you create an efficient, searchable repository:

1. Knowledge Management Tools
These tools are designed to organize notes, code, and references:

Notion: Highly flexible, great for creating databases with custom properties (tags, categories, links to files). You can embed PBIX files, add code blocks for DAX, and even link YouTube videos.

Evernote: Good for organizing notes, with powerful search features. You can tag notes and even clip web pages directly from the browser.

Obsidian: Ideal for managing interconnected notes with Markdown. You can use it with a plugin to support code snippets and organize DAX formulas in a knowledge graph style.

2. Code Repositories (with Documentation)
If your focus is on version control and code management:

GitHub/GitLab/Bitbucket: Create repositories for DAX scripts, PBIX files (as artifacts or linked externally), and documentation. Markdown files can be used to document concepts, and you can tag or label issues for easy searching.

Gitea (self-hosted): Lightweight, open-source alternative if you prefer hosting it yourself.

3. Database Systems for Advanced Search
If you’re tech-savvy, you could create a custom solution:

SQLite or PostgreSQL: Store DAX formulas as entries in a database with metadata (tags, descriptions, links to PBIX files, etc.). Build a simple front-end app or even use SQL queries to search.

Elasticsearch: For advanced search capabilities, especially if you have thousands of entries.

4. Personal Wiki Tools
MediaWiki: Similar to Wikipedia, great for creating a structured knowledge base.

DokuWiki: Lightweight and easy to set up, supports syntax highlighting for code snippets.

5. Hybrid Approach
Combine tools for different purposes:

Notion for documentation + GitHub for version-controlled scripts + Obsidian for personal knowledge graph.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[Riksall · Accepted solution]

Thanks  for the extensive list, will look into the ideas.

[xifeng_L]

Perhaps you could try deploying one yourself using gitbook, which is open source.

Project address: https://github.com/GitbookIO/gitbook

[techies]

Hi @Riksall 

https://youtu.be/3gpXMMRJjw8?si=kBNo7A8VqLxi6BSG