What Is DAX?

DAX (Data Analysis Expressions) is a formula language developed by Microsoft used in Power BI, SQL Server Analysis Services (SSAS), and Power Pivot for Excel. DAX is used to define calculated columns, measures, calculated tables, and row-level security rules. It extends Excel's formula capabilities with functions designed for relational data, dynamic aggregation, and time-intelligence calculations.  

DAX is essential for any Power BI data model that goes beyond simple visualizations. Microsoft's official DAX reference is available at Microsoft Learn DAX Reference.  

What Is a DAX Calculated Table?

A calculated table in Power BI is a table defined by a DAX expression rather than loaded from an external data source. You create one by clicking New Table in the Modeling tab and writing a DAX formula that returns a table. Two common DAX functions for creating calculated tables are:  

• DATATABLE — Defines a table inline with column names, data types, and row values. Useful for small lookup tables, parameter tables, or static reference data embedded in the data model.

• TABLE constructor — Uses curly brace syntax { } to define a table from rows of values. More concise for simple data, with column names auto-generated as Value1, Value2, etc.

This tool generates both formats from your Excel data, ready to paste directly into Power BI's DAX formula bar.  

What Is Excel to DAX Table Converter?

Excel to DAX Table is a free online tool that converts spreadsheet data from Excel files (.xlsx, .xls, .xlsm) into DAX table expressions that you can paste directly into Power BI. Instead of manually typing DATATABLE or TABLE expressions row by row, upload your spreadsheet and get the complete DAX code instantly.  

All processing happens in your browser — your files are never uploaded to any server.  

Core Features

• DATATABLE Format — Generate a full DATATABLE expression with explicit column names and data types: DATATABLE("Column1", STRING, "Column2", INTEGER, {...}).

• TABLE Constructor Format — Generate a concise TABLE expression using curly brace syntax: {("value1", 123), ("value2", 456)}.

• Custom Table Name — Set the DAX variable name for your calculated table (e.g., MyTable = DATATABLE(...)).

• Indentation Control — Choose 2-space, 4-space, or tab indentation.

• Built-in Table Editor — Edit cells, add or remove rows and columns, transpose, deduplicate, remove empty rows, apply case transforms, and find-and-replace before conversion.

• Multi-Sheet Support — Select which sheet to work with in multi-sheet workbooks.

• 100% Client-Side Processing — Files are parsed and converted entirely in your browser.

• Copy and Download — Copy the DAX output to clipboard or download as a file.

How to Use Excel to DAX Table

Step 1: Upload or Enter Your Data

Drag and drop an Excel file (.xlsx, .xls, or .xlsm) onto the upload area, or click to browse. Alternatively, click Enter Data to type or paste data directly.  

Step 2: Edit Your Data (Optional)

After loading, your data appears in an editable table. Use the toolbar to modify cells, add or remove rows and columns, transpose data, remove duplicates and empty rows, change text case, or find and replace values. Toggle First Row as Header to define column names.  

Step 3: Configure DAX Options

In the Properties panel on the right:  

• Format — Choose DATATABLE for explicit column definitions with data types, or TABLE for a concise curly-brace syntax.

• Indent — Select 2 Spaces, 4 Spaces, or Tab.

• Table Name — Enter a name for the DAX variable (e.g., Products). The output will be Products = DATATABLE(...).

DATATABLE vs TABLE Output Comparison

Given this Excel data:

DATATABLE format output:

Products =DATATABLE (
 "Product", STRING,
 "Price", DOUBLE,
 {
   ( "Widget A", 29.99 ),
   ( "Widget B", 49.99 )
 }
)

TABLE constructor format output:

Products ={
 ( "Widget A", 29.99 ),
 ( "Widget B", 49.99 )
}

Step 4: Convert and Paste into Power BI

Click Convert to generate the DAX expression. The output appears in the Output Data panel. Click Copy to Clipboard to copy it. In Power BI Desktop, go to Modeling > New Table, paste the DAX code into the formula bar, and press Enter.  

Common Use Cases

• Lookup Tables — Create static lookup or mapping tables (currency codes, status mappings, category hierarchies) directly in Power BI without external data sources.

• Parameter Tables — Define "What-If" parameter tables for scenario analysis and sensitivity testing in Power BI reports.

• Date Tables — Generate custom date/calendar tables with fiscal year definitions, holiday lists, or business-specific period mappings.

• Reference Data — Embed reference data (exchange rates, tax brackets, SLA thresholds) as calculated tables that travel with the PBIX file.

• SSAS Tabular Models — Generate DAX expressions for calculated tables in SQL Server Analysis Services tabular models.

• Power Pivot for Excel — Create DAX calculated tables in Excel's Power Pivot data model.

• Prototyping — Quickly scaffold sample data tables for Power BI report prototyping and demos.

• Row-Level Security Tables — Define role-based access mapping tables for Power BI security.

DAX Data Types Reference

Frequently Asked Questions (FAQ)

• Is my Excel data uploaded to a server?

  No. All file parsing and DAX generation happens entirely in your browser using client-side JavaScript. Your files are never uploaded, transferred, or stored on any server. The tool works offline once the page has loaded.

• What is the difference between DATATABLE and TABLE formats?

  DATATABLE explicitly defines column names and data types (STRING, INTEGER, DOUBLE, etc.), giving you full control. TABLE constructor uses a shorter curly-brace syntax { } with auto-generated column names (Value1, Value2). Use DATATABLE when you need named columns and specific types. Use TABLE for quick prototyping with simple data.

• How do I paste the DAX code into Power BI?

  In Power BI Desktop, go to the Modeling tab on the ribbon, click New Table, and paste the DAX expression into the formula bar at the top. Press Enter to create the calculated table. The table will appear in your data model with the data you defined.

• What Excel file formats are supported?

  The tool supports .xlsx (Excel 2007+), .xls (Excel 97-2003), and .xlsm (macro-enabled) files. Multi-sheet workbooks are supported — use the sheet selector to choose which sheet to convert.

• Can I edit the data before converting?

  Yes. After uploading your file, the built-in table editor lets you modify cell values, add or remove rows and columns, transpose data, remove duplicates and empty rows, change text case, and find-and-replace — all before generating DAX output.

• Is there a limit on file size or number of rows?

  Since processing is entirely client-side, the practical limit depends on your device's available memory. However, DAX calculated tables are best suited for small to medium datasets (typically under a few hundred rows). For large datasets, consider importing the data directly into Power BI instead of using a DAX calculated table.

• When should I use a DAX calculated table vs. importing data?

  Use DAX calculated tables for small static reference data (lookup tables, parameter tables, mappings) that should be embedded in the PBIX file. For large or frequently updated datasets, import the data from Excel, CSV, database, or other sources using Power BI's Get Data feature. DAX calculated tables are re-evaluated on every data refresh, which can impact performance for large tables.

• Can I use this tool without uploading a file?

  Yes. Click the Enter Data button to open a blank editor where you can type or paste data manually, then convert it to DAX as usual.