Logo

Markdown to DAX Converter

Transform Markdown tables into DAX calculated tables for Power BI and Analysis Services

Markdown Input

DAX Output

About Markdown to DAX Converter

Convert Markdown tables to DAX (Data Analysis Expressions) table expressions for Power BI, Power Pivot, and SQL Server Analysis Services. Create calculated tables directly from your documentation.

Key Features

  • Three DAX Formats: TABLE(), DATATABLE(), and ROW()/UNION() expressions
  • Automatic Type Detection: Detects INTEGER, DOUBLE, BOOLEAN, DATETIME, and STRING types
  • BLANK() Support: Empty cells converted to BLANK() function
  • Custom Table Names: Configure your calculated table name
  • Usage Instructions: Optional comments with implementation guidance
  • String Escaping: Properly escapes quotes in DAX strings
  • File Download: Save as .dax file

How to Use

  1. Input Markdown Table: Paste your Markdown table or upload a .md file
  2. Set Table Name: Enter the desired calculated table name
  3. Choose Format: Select TABLE(), DATATABLE(), or ROW()/UNION() format
  4. Review Output: The DAX expression generates automatically
  5. Copy to Power BI: Paste into Power BI's "New Table" formula bar

DAX Formats

  • TABLE(): Simple format for basic data tables without column definitions
  • DATATABLE(): Explicit column types for better performance and type safety
  • ROW()/UNION(): Calculated table format with named columns, ideal for small reference tables

Example Conversion

Markdown Input:

| Product | Price | Quantity |
|---------|-------|----------|
| Laptop | 999.99 | 15 |
| Mouse | 29.99 | 50 |

DAX Output (DATATABLE format):

MyTable = DATATABLE(
    "Product", STRING,
    "Price", DOUBLE,
    "Quantity", INTEGER,
    {
        {"Laptop", 999.99, 15},
        {"Mouse", 29.99, 50}
    }
)

Common Use Cases

  • Reference Tables: Create lookup tables for Power BI reports
  • Static Data: Add configuration or mapping tables
  • Test Data: Generate sample data for development
  • Documentation to Data: Convert specification tables to Power BI tables
  • Quick Prototyping: Rapidly create tables for proof-of-concept dashboards

Data Type Detection

  • INTEGER: Whole numbers (e.g., 42, 100)
  • DOUBLE: Decimal numbers (e.g., 3.14, 99.99)
  • BOOLEAN: TRUE or FALSE values
  • DATETIME: Date patterns (YYYY-MM-DD or MM/DD/YYYY)
  • STRING: All other text data
  • BLANK(): Empty cells

How to Add to Power BI

  1. Open Power BI Desktop
  2. Go to Modeling tab
  3. Click New Table
  4. Paste the generated DAX expression
  5. Press Enter to create the table

About DAX

DAX (Data Analysis Expressions) is a formula language used in Power BI, Power Pivot, and SQL Server Analysis Services. It's designed for data modeling, calculation, and analysis in business intelligence applications.

Privacy & Security

All conversions happen locally in your browser. Your Markdown data is never uploaded to any server, ensuring complete privacy and security.