Where to Write DAX in Power BI?

So you're ready to level up your Power BI reports with DAX, but the first big question is often: where do you actually write the code? It's not as simple as a single formula box. Power BI gives you several different places to write DAX expressions, and each one is designed for a specific purpose. Understanding which to use and when is the key to creating efficient, powerful, and easy-to-manage reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

This tutorial will walk you through the four main places you can write DAX in Power BI. We'll cover what they are, how to find them, and exactly when you should be using each one for your data analysis.

A Quick Refresher: What is DAX?

Before we jump into the "where," let's do a super-fast recap of the "what." DAX stands for Data Analysis Expressions. It's a formula language used in Power BI, Power Pivot for Excel, and SQL Server Analysis Services to create custom calculations on your data models. Think of it like Excel formulas on steroids - specifically built for relational data and robust analysis.

In Power BI, you'll use DAX to create three foundational types of calculations, and knowing these is essential to understanding where to write your code:

• Calculated Columns: Adding a new column to a table based on a calculation.
• Measures: Creating a calculation that aggregates data, like a sum or an average.
• Calculated Tables: Creating an entirely new table using a DAX formula.

Each of these is created in a different context, which we will explore now.

1. Calculated Columns: Row-by-Row Context

What Are They?

A calculated column physically adds a new column to one of your tables. The DAX formula for a calculated column is evaluated for each row in that table, just like a formula in an Excel table. This calculation happens when you refresh your dataset, and the results are stored in your data model. Because the values are pre-calculated and stored, they consume memory (RAM) and increase your file size.

Calculated columns are best for when you need a static value tied to each individual row that you want to use in a slicer, as a filter, or on an axis in a visual.

Common Example: You have a Sales table with Unit Price and Quantity columns, but no Total Revenue column. You could create a calculated column to compute the revenue for each individual transaction.

Revenue = Sales[Unit Price] * Sales[Quantity]

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Where to Write the DAX?

Creating a calculated column is done within the Data View of Power BI Desktop. Here's the step-by-step process:

1. Navigate to the Data View by clicking the table icon on the left-hand navigation pane.
2. In the Data pane on the right side of the screen, select the table you want to add the column to (e.g., the 'Sales' table).
3. This will open the Table tools tab in the Power BI ribbon at the top of the window. Click on the New column button.
4. The formula bar will now appear at the top of the data grid, waiting for your input. This is where you write the DAX formula for your calculated column.
5. Type your formula, such as Revenue = Sales[Unit Price] * Sales[Quantity], and press Enter. You will immediately see the new 'Revenue' column appear in your table, with a value calculated for every single row.

2. Measures: On-the-Fly Aggregations

What Are They?

Measures are the heart and soul of analytical power in Power BI. Unlike calculated columns, measures are calculated "on the fly" when you add them to a report visual. They don't store any data in your model, so they have a minimal impact on file size. Instead, their DAX formula is evaluated based on the current "filter context" — that is, any slicers, filters, or row and column headers active in the visual.

Measures are almost always used for aggregations. You'll use them to calculate KPIs and any value you want to see in the "Values" field of a visual.

Common Example: You want to calculate the total revenue across all sales. A measure is the perfect tool for this.

Total Revenue = SUM(Sales[Revenue])

If you put this measure on a card, it shows the grand total. If you put it in a bar chart with Product Category on the axis, it automatically calculates the total revenue for each category.

Where to Write the DAX?

Measures are typically created from the Report View or Data View.

1. Make sure you are in the Report View (the bar chart icon in the left-hand navigation). This is the default view where you build your dashboards.
2. In the Data pane on the right, you can either right-click the table where you want the measure to live and select New measure, or you can simply click on the table to select it.
3. With the table selected, click the New measure button in the Home or Modeling tab in the ribbon.
4. The formula bar will appear, just like it did for calculated columns.
5. Type your DAX formula, such as Total Revenue = SUM(Sales[Revenue]), and press Enter. A tiny calculator icon will appear next to your new measure in the Data pane, distinguishing it from regular columns.

Pro Tip: For better organization, many analysts create a dedicated "Measures Table" to hold all of their DAX measures in one place, rather than scattering them across different data tables.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Calculated Tables: Dynamically Generating Tables

What Are They?

Sometimes you need an entirely new table in your model that doesn't exist in your source data. Calculated tables allow you to use a DAX formula to generate a new table. This could be a copy of another table, a distinct list of values, or a dynamically created date table, which is a very common use case.

Like calculated columns, these tables are computed during a data refresh and are physically stored in your model.

Common Example: Creating a dedicated, robust Date dimension table from scratch. The CALENDARAUTO() function in DAX can automatically scan your model for all dates and create a comprehensive table of all years, months, quarters, and days within your data's range.

Date Table = CALENDARAUTO()

Where to Write the DAX?

Calculated tables are created from the Modeling tab in Power BI.

1. You can be in either the Report View or the Data View for this.
2. Click on the Modeling tab in the ribbon at the top of the window.
3. Click the New table icon.
4. The formula bar appears again. This time, it's asking for a DAX formula that returns a table.
5. Enter your formula, like Date Table = CALENDAR(DATE(2023,1,1), DATE(2024,12,31)), and press Enter. Power BI will execute the formula, and your newly created table will appear in the Data pane on the right.

You can then establish relationships between your new calculated table and other tables in your model from the Model View.

4. DAX Query View: The Power User’s Sandbox

What Is It?

The DAX Query View is a newer and more advanced addition to Power BI. This view is not for creating measures, columns, or tables that directly live in your report. Instead, think of it as a development environment or a scratchpad where you can write and test ad-hoc DAX queries to explore your data model. It lets you test pieces of a complex formula, debug a malfunctioning measure, or simply analyze a slice of your data without building a temporary visual.

This environment uses DAX query language, which includes functions like EVALUATE to define and run a query.

Common Example: You want to quickly check the output of a specific part of a measure that isn't working correctly, or see the top 10 products by profit without dragging anything onto the report canvas.

EVALUATE
TOPN(
    10,
    SUMMARIZECOLUMNS(
        'Products'[Product Name],
        "Total Profit", [Total Profit]
    ),
    [Total Profit],
    DESC
)

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Where to find It?

The DAX Query View has its own dedicated spot in the main navigation.

1. Click the DAX Query View icon, the fourth one down in the left-hand navigation pane of Power BI Desktop.
2. This opens up a dedicated query editor panel.
3. You can type your DAX query directly into the editor and click the Run button. The results of your query will instantly appear in a results grid at the bottom, allowing for quick iteration and validation.

Again, remember this is for testing and exploring — the queries you run here do not directly create permanent measures or columns for your report visuals.

When to Use Which: A Quick Summary

Feeling a bit overwhelmed? Here's a quick cheat sheet to help you decide where to go:

• Write a Calculated Column when: You need a static, row-by-row value. This is perfect for categories you want to use in a slicer or on a chart axis (e.g., binning customers by age group).
• Write a Measure when: You need an aggregated result that responds to report filters. This is for nearly all of your key business calculations like "Total Sales," "Profit Margin %," or "YOY Growth." When in doubt, start with a measure first.
• Write a Calculated Table when: You need to generate a completely new table that doesn't exist in your source data, such as a date table or a "what-if" parameter table to aid your analysis.
• Use the DAX Query View when: You're debugging a complex measure, exploring a concept, or just want to quickly validate data without building a visual on your report canvas. It's the data pro's testing ground.

Final Thoughts

Knowing where to write your DAX formulas is fundamental to becoming proficient in Power BI. Whether you're adding a static column in the Data View, creating a dynamic measure from the ribbon, or troubleshooting with the DAX Query View, each location serves a distinct purpose in transforming raw data into meaningful business insights. Using the right tool for the job will help you build reports that are not only powerful but also efficient and easy to maintain.

If you'd rather spend your time analyzing results instead of debugging formulas, we understand. We built Graphed to do the heavy lifting for you. Simply connect your data sources like Google Analytics, Shopify, or Salesforce and ask for what you need in plain English - like "create a report comparing revenue and ad spend by campaign for last month." We build the live, interactive dashboard for you instantly, so you can skip the steep learning curve of tools like Power BI and get straight to the impactful business decisions.