Festival Season OfferUp to 25% off on all our programmes — claim it before you enrol
← All Career InsightsData Analytics

What is DAX in Power BI and which functions should beginners learn?

DAX (Data Analysis Expressions) is the formula language of Power BI. Beginners should first understand the difference between measures and calculated columns, then learn SUM, AVERAGE, COUNTROWS and DISTINCTCOUNT, DIVIDE for safe ratios, CALCULATE for changing the filter context, FILTER and ALL, and time-intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR.

Why DAX is the step after building your first visuals

Dragging fields onto a chart gets you simple totals. Real business questions, such as profit margin, growth versus last year or sales for one region only, need calculations. DAX is how you write them once and reuse them across every visual in a report.

It looks like Excel formulas, but it works on whole tables and responds to the filters on the report page. Understanding that one idea makes most DAX problems much easier.

Measures versus calculated columns

The first decision in almost every DAX task.

Measure

Calculated at the moment a visual needs it, using whatever filters are active, such as Total Sales for the selected month. Use measures for most numbers in a report.

Calculated column

Calculated once for every row when the data refreshes and stored in the table, such as a Price Band label for each product. Use it when you need a value per row to filter or group by.

Filter context

The filters coming from slicers, visuals and rows in a table. A measure gives a different result in each cell because each cell has a different filter context.

Row context

The current row when DAX evaluates a calculated column or an iterator such as SUMX. It is how DAX works row by row.

The DAX functions to learn first

These cover most beginner and interview tasks:

  • SUM, AVERAGE, MIN and MAX – basic aggregations of a column.
  • COUNTROWS and DISTINCTCOUNT – how many rows, and how many unique customers or orders.
  • DIVIDE – a safe division that returns blank instead of an error when the denominator is zero, ideal for margins and ratios.
  • SUMX – an iterator that calculates something row by row, such as quantity × price, then adds it up.
  • CALCULATE – the most important DAX function: it evaluates an expression with changed filters, such as sales for one region only.
  • FILTER and ALL – build a filtered table, or remove filters, often inside CALCULATE for shares of total.
  • TOTALYTD and SAMEPERIODLASTYEAR – year-to-date totals and last-year comparisons, using a proper date table.

Write your first useful measures

Practise on any sales dataset with an orders table and a date table.

  1. Create a date table

    Build or import a calendar table, mark it as the date table and relate it to your orders. Time-intelligence functions rely on it.

  2. Start with Total Sales

    Write Total Sales = SUM(Orders[Sales]) and use it in a card and a chart by month.

  3. Add a ratio

    Write Profit Margin = DIVIDE([Total Profit], [Total Sales]) and format it as a percentage.

  4. Use CALCULATE

    Write a measure for one segment, such as sales in a single region, and compare it with the total in the same visual.

  5. Add time intelligence

    Write Sales LY with SAMEPERIODLASTYEAR, then a growth measure that divides the difference by last year's sales.

Quick answers about DAX in Power BI

Short answers to the questions analysts search for most.

What is DAX in Power BI?

DAX stands for Data Analysis Expressions. It is the formula language used in Power BI, Power Pivot and Analysis Services to create measures, calculated columns and calculated tables.

Is DAX hard to learn?

The basics are approachable, especially if you know Excel formulas. The harder part is understanding filter context and CALCULATE, which comes with practice on real reports.

What is the difference between a measure and a calculated column?

A measure is calculated on demand using the report's current filters and is not stored per row. A calculated column is computed for every row at refresh time and stored in the table.

Why is CALCULATE so important in DAX?

CALCULATE lets you change the filters a calculation uses, which is how you build comparisons such as one region versus total, this year versus last year, or a share of the overall figure.

Do data analyst interviews ask about DAX?

For Power BI roles, often yes. Expect questions on measures versus calculated columns, CALCULATE, and writing a simple year-on-year or percentage-of-total measure.

Go further with Power BI and reporting

See where Power BI sits in the syllabus, or read the guides that build on it.

See the Data Analytics programmeRead: build your first Power BI dashboardRead: define KPIs before building a dashboardRead: SQL joins explained with examplesRole: BI AnalystRole: Dashboard DeveloperBrowse all Career Insights

Write five measures this week

Load a sample sales dataset into Power BI and write Total Sales, Profit Margin, a single-region CALCULATE measure, Sales Last Year and Year-on-Year Growth. Those five measures cover most of what beginner DAX interviews ask.

Train for a Data Analytics role

The same programme, duration and fees, with the learning path built around one job role.

Data AnalystBI AnalystBusiness AnalystReporting AnalystAnalytics ConsultantDashboard Developer

Learn Power BI and DAX with a mentor

Ask our team how the Data Analytics programme in Madhapur, Hyderabad teaches Excel, SQL, Power BI and DAX with real datasets.

Our admissions team will call you back within 90 minutes.
AddressHouse No. 3-535, 3rd Floor A Section, LR Towers, 100 Feet Road, Ayyappa Society, Madhapur, Hyderabad, Telangana 500081