DAX for Power BI

DAX tools

• DAX FormatterFormat measures and expressions using SQLBI's published formatting rules.
• Power BI Date Table GeneratorGenerate the date table that time-intelligence measures rely on, as a DAX calculated table.

Power BI DAX Measures Library

175 measures in 16 categories, each with the full code, notes on what it needs and related measures. Search the whole Power BI DAX Measures Library, or jump straight into a category:

• Basics 14
• Time Intelligence 30
• Ranking and Top N 9
• Filters and Context 6
• Dates and Calendar 5
• Customers and Retention 13
• Formatting and Display 14
• Utility 4
• Finance 11
• Inventory and Operations 10
• HR 10
• Projects and Support 11
• Marketing 9
• Data Quality and Governance 10
• Statistics 11
• Advanced Patterns 8

Featured measures

The measures other entries in the library build on or point to most often, a good place to start.

• Total SalesSums a revenue column across whatever filter context is currently applied.
• Previous Year SalesShifts the current filter context back exactly one year and re-evaluates sales.
• New CustomersCounts customers whose very first purchase (ever) falls inside the current date filter.
• Rolling 12 Month AverageAverages monthly sales over the trailing twelve months, smoothing out seasonal spikes.
• Z-ScoreCalculates how many standard deviations a value is from the mean, for spotting outliers.
• Stock on HandSums the current on-hand inventory quantity across the current filter context.
• Total OrdersCounts each order once, even when an order has several line items.
• Mode (Most Frequent Value)Returns the most frequently occurring value in a column across the current filter context.
• Repeat Purchase RateExpresses the percentage of customers who placed more than one order, out of all customers.
• Headcount (End of Period)Counts active employees as of the last date in the current filter context, a semi-additive measure.
• Running BalanceAccumulates a transaction amount into a running balance up to the current date filter context.
• Cumulative BudgetAccumulates the budgeted amount from the start of the year through the current date filter context.

Related topics

• Power Query M for Power BIPower Query M snippets and the M formatter, including date tables built in M.