DAX Toolkit

DAX Formatter

Paste your DAX code and format it with proper indentation and syntax highlighting.

Input

Formatted Output

Formatted DAX will appear here...

DAX Reference

Browse and search 100+ DAX functions with syntax, descriptions, and examples.

DAX Snippets

Ready-to-use DAX patterns. Replace the highlighted placeholders with your own table and column names.

DAX User-Defined Functions

Package reusable DAX logic as a named function using the new FUNCTION keyword. Define once, call anywhere — in measures, calculated columns, visual calculations, and other UDFs.

⚡
Preview feature DAX UDFs (introduced Sept 2025) are currently in preview in Power BI Desktop. Enable under File → Options → Preview features → DAX user-defined functions, then restart.
Basic syntax
DEFINE
    /// Optional description
    FUNCTION <Name> =
        ( <param> : <TYPE> ) =>
            <function body>

EVALUATE
{ <Name> ( args ) }

Date Table Generator

Generate a complete DAX date table with fiscal year support and ISO week numbers.

Configuration

Generated DAX

Configure and click "Generate" to create your date table...

Format String Finder

Build Power BI number format strings visually. Choose a display category, style, and options to generate the perfect format string.

Theme Builder

Design a Power BI report theme visually. Pick your colors, preview how they look, check accessibility, and download the theme JSON to import into Power BI.

Relationship Types

Understand Power BI table relationships — cardinality, cross-filter direction, and active vs. inactive. Each type is explained with a visual diagram and when to use it.

Visual Calculations

Reference for Power BI visual calculations — window functions that work directly on visual-level data. Each card includes syntax, an example, and a sample preview table.

Visual Picker

Not sure which visual to use? Browse the catalog of Power BI visuals with guidance on when each one shines, when to avoid it, and a sample of dummy data.

Measure Dependencies

Paste your DAX measures to visualize how they reference each other. See the dependency graph and identify base, intermediate, and top-level measures.

Your Measures

Paste your DAX measures above and click Analyze.

DAX Performance Tips

Paste your DAX code to detect common anti-patterns and performance issues, or browse all rules below.

Analyze Your DAX

Paste some DAX code and click Analyze to check for performance issues.

All Performance Rules

A complete reference of DAX anti-patterns and best practices.

Power BI Keyboard Shortcuts

Quick reference for Power BI Desktop keyboard shortcuts. Search or filter by category.