Logo

MediaWiki to DAX Converter

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

MediaWiki Input

DAX Output

About MediaWiki to DAX Converter

Convert MediaWiki tables to DAX (Data Analysis Expressions) table expressions for Power BI, Power Pivot, and SQL Server Analysis Services. Create calculated tables directly from Wikipedia and other wiki data.

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 MediaWiki Table: Paste your MediaWiki table or upload a .wiki 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

MediaWiki Input:

{| class="wikitable" border="1"
! 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

  • Wikipedia Data: Import Wikipedia tables into Power BI reports
  • Reference Tables: Create lookup tables from wiki data
  • Static Data: Add configuration or mapping tables
  • Wiki to BI: Convert wiki documentation 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 MediaWiki data is never uploaded to any server, ensuring complete privacy and security.