Code, run, and share DAX

Write your DAX queries, try them and share them easily with DAX.do

DAX is the query language that powers Microsoft products such as Power BI, Analysis Services, and Power Pivot for Excel.
Browse the full language reference on DAX Guide.
A project by SQLBI



Format
Run Run line

Editor





Results


DAX Formatter options

Spacing



Lines


Telemetry

Help us understand how you use this tool and how to improve it. No personal information is collected.

v1.1.7 - 2022-12-27
  • Currency
    • Currency
    • Currency Code
    • CurrencyKey
       
  • Customer
    • Birth Date
    • Company Name
    • Contact Info
      • Phone
      • Title
    • Customer Code
    • Customer Type
    • CustomerKey
       
    • Date First Purchase
    • Education
    • Gender
    • Geography
      • Address Line 1
      • Address Line 2
      • City
      • Continent
      • CountryRegion
      • State
    • Name
    • Occupation
    • Personal Info
      • Cars Owned
      • Children At Home
      • House Ownership
      • Marital Status
      • Total Children
      • Yearly Income
  • Date
    • Asia Season
    • Calendar
      • Calendar Year
      • Calendar Year Month
      • Calendar Year Month Number
      • Calendar Year Number
      • Calendar Year Quarter
      • Calendar Year Quarter Number
    • Date
      3
    • DateKey
    • Day of Week
    • Day of Week Number
    • Europe Season
    • Fiscal
      • Fiscal Month
      • Fiscal Month Number
      • Fiscal Quarter
      • Fiscal Quarter Number
      • Fiscal Year
      • Fiscal Year Number
      • Fiscal Year Quarter
      • Fiscal Year Quarter Number
    • Holiday Name
    • Is Holiday
    • Month
    • Month Number
    • North America Season
    • Working Day
  • Product
    • Available Date
    • Brand
    • Category
    • Color
    • Manufacturer
    • Product Code
    • Product Name
    • ProductKey
       
    • Subcategory
    • Unit Cost
    • Unit Price
    • Weight
    • Weight Unit Measure
  • Sales
    • Relationships
      • [Order Date] *1 'Date'[Date]
      • [Delivery Date] *1 'Date'[Date]
      • [Due Date] *1 'Date'[Date]
      • [CustomerKey] *1 Customer[CustomerKey]
      • [ProductKey] *1 'Product'[ProductKey]
      • [CurrencyKey] *1 'Currency'[CurrencyKey]
    • # Quantity
    • CurrencyKey
       
    • CustomerKey
       
    • Delivery Date
       
    • DeliveryDateKey
    • Discount Amount
    • Due Date
       
    • DueDateKey
    • Gross Amount
    • Margin
    • Margin %
    • Net Price
    • Order Date
       
    • Order Line Number
    • Order Number
    • OrderDateKey
    • ProductKey
       
    • PromotionKey
    • Quantity
    • Sales Amount
    • StoreKey
    • Total Cost
    • Unit Cost
    • Unit Discount
    • Unit Price
This website is offered by SQLBI.
Ln 1, Col 1