Where is DAX in Power BI?

If you're looking for a "DAX" button or menu in Power BI, you won't find one. That's because DAX isn't a feature you click on, it's the powerful formula language that works behind the scenes in your reports. This guide will show you exactly where you can write DAX formulas to create more insightful analytics.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is DAX, Anyway? A Quick Refresher

DAX stands for Data Analysis Expressions. Think of it as the advanced version of the formulas you use in an Excel sheet. Just like you might type =SUM(A1:B10) in Excel to add up numbers, you use DAX in Power BI to create new information from the data you’ve already imported.

The core purpose of DAX is to build custom calculations that don’t exist in your original data source. Want to calculate profit, year-over-year sales growth, or the average order value for a specific product line? DAX is how you get it done. It allows you to transform raw data into meaningful business metrics and KPIs.

The Three Main Places You'll Write DAX in Power BI

While DAX is used throughout your data model, there are only three places where you actively type DAX expressions: when you're creating a new calculated column, a new measure, or a new table.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Creating a Calculated Column

A calculated column adds a brand-new column to one of your existing tables. The DAX formula you write runs for every single row in that table and stores the result, almost like a static value.

Where to Find It

You can create a calculated column from the Data View.

1. Navigate to the Data View by clicking the table icon on the left-hand navigation bar.
2. Select the table you want to add the column to from the Fields pane on the right.
3. In the top ribbon, the Table tools menu will appear. Click the New column button.

A formula bar will appear at the top, ready for you to write your DAX expression.

Example: Calculating Profit Per Sale

Let's say you have a 'Sales' table with SalePrice and UnitCost columns, but no profit column. You can create one with DAX.

You’d click New column and type this formula into the formula bar:

Profit = Sales[SalePrice] - Sales[UnitCost]

Once you press Enter, Power BI calculates the profit for every single row in your 'Sales' table and adds the result to a new 'Profit' column. This value is computed during data refreshes and physically stored within your data model, which increases the file size.

When to Use a Calculated Column

• When you need to perform calculations based on other values in the same row.
• When you need a static category for filtering or slicing, like categorizing customers as ‘High Value’ or ‘Low Value’ based on their purchase history.
• When the value needs to be used as an axis on a chart or slicer without aggregation (e.g., grouping sales into Price Bins like '$0-$50', '$51-$100').

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

2. Creating a Measure

Measures are arguably the most common and powerful way to use DAX. A measure is a dynamic calculation that produces a single value based on the context of your report. It doesn’t create a new column or add data to your tables, instead, it calculates a value on the fly when you add it to a visual like a card, gauge, or chart.

Where to Find It

Measures can be created from nearly any view (Report, Data, or Model).

1. In the Fields pane on the right, right-click on the table where you want the measure to live.
2. Select New measure from the context menu.

Alternatively, you can select the table and click the New measure button in the Home ribbon or Table tools ribbon.

Example: Calculating Total Sales

Imagine you have a 'Sales' table with a SalePrice column. To create a measure that calculates the total sales across your entire dataset, you would use this DAX formula:

Total Sales = SUM(Sales[SalePrice])

Unlike a calculated column, this formula doesn't store any values. When you drag 'Total Sales' into a report visual, Power BI calculates the result instantly based on any filters applied (like a date slicer, a product slicer, or chart axis). If a user filters by the year '2023', the measure re-calculates to show the total sales just for that year. This dynamic evaluation is what makes measures so powerful for analytics.

When to Use a Measure:

• When you are calculating aggregates like sums, averages, counts, minimums, or maximums.
• When you want values to respond dynamically to filters and interactions within your report.
• When you need to calculate KPIs and core business metrics that will appear in cards, charts, and tables (e.g., Year-over-Year Growth, Click-Through Rate, Average Order Value).
• Almost any time you’re working with percentages or ratios.

3. Creating a Calculated Table

The third place you'll use DAX is to create a completely new table in your data model. Instead of pulling data from a source, this entire table is generated by a DAX formula. This is often used for creating specialized tables for better modeling, like a dedicated date or calendar table.

Where to Find It

You can create a calculated table from the Report View or Data View.

1. Click on the Modeling tab in the top ribbon.
2. Click the New table button.

Once again, this brings up the formula bar where you can define your table.

Example: Creating a Dynamic Calendar Table

Creating a dedicated table for dates is a Power BI best practice that unlocks special time-intelligence functions. You can create a dynamic one with just one line of DAX:

Calendar = CALENDARAUTO()

This simple function scans the date columns in your entire data model, finds the earliest and latest dates, and constructs a full table of all dates in between those two points. You can then use this table in slicers or for calculations like SAMEPERIODLASTYEAR() or month-over-month growth.

When to Use a Calculated Table:

• For creating a robust Date Table to support time intelligence calculations. This is the most common use case.
• To create a new, filtered, or summarized version of an existing table without modifying your original data sources.
• For building specialized lookup tables that may not exist in your source data but are needed for analysis (e.g., creating a table with unique customer segments).

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Formula Bar Experience

Each time you create a new column, measure, or table, the DAX formula bar will appear at the top of the user interface. It’s designed to help you write formulas more easily:

• IntelliSense Autocomplete: As you start typing, Power BI suggests relevant functions and table or column names. This prevents typos and helps you find what you're trying to reference.
• Syntax Colorization: DAX functions are colorized differently from your table or column names, which makes formulas much easier to read.
• Shift + Enter for Long Formulas: For complex expressions, pressing Shift + Enter will expand the formula bar into a larger multi-lined editor, allowing you to organize your code for better readability.

Final Thoughts

So, where is DAX in Power BI? Everywhere and nowhere at once. It's not a button or feature but the language you speak to your data in the formula bar. Whether you’re creating a calculated column for row-level logic, a measure for dynamic KPIs, or an entire calculated table for better modeling, you are using DAX. Understanding which of these three options to use - and when - is the key to unlocking truly powerful reporting.

Building reports from scratch in Power BI means mastering DAX along with connecting all your data sources. This can be a steep learning curve. We created Graphed to help eliminate that learning curve by connecting your data in real-time and simplifying the visual and report creation process. Try Graphed and see how it can streamline your workflow.