DAX is one of the most important skills for any Power BI job. Most interviewers ask at least a few DAX questions, no matter what level you are applying for. This article has 50 common DAX interview questions and answers to help you prepare.
The questions cover basics, syntax, context, functions, time intelligence, and advanced topics. We have also added code examples so you can see how each DAX formula looks in real life. The language is kept simple, so anyone can follow along, even if you are new to Power BI.
What Is DAX in Power BI?
DAX stands for Data Analysis Expressions. It is a formula language used in Power BI, Excel Power Pivot, and SQL Server Analysis Services. DAX is used to build measures, calculated columns, and calculated tables.
DAX formulas look a bit like Excel formulas, but they work with tables and columns instead of single cells. This makes DAX very powerful for building reports that update automatically as data changes.
DAX Data Types
Before we go into the interview questions, here is a quick table of the main data types used in DAX.
| Data Type | Example |
| Whole Number | 10, 250, 1000 |
| Decimal Number | 10.5, 99.99 |
| Currency | $100.00 |
| Date and Time | 01/01/2026 |
| Text | “Power BI” |
| True or False (Boolean) | TRUE, FALSE |
Categories of DAX Functions
DAX functions are grouped into categories. Knowing these groups will help you answer many interview questions with confidence.
| Category | What It Is Used For | Example Functions |
| Aggregation | Adding up or summarizing values | SUM, AVERAGE, MIN, MAX |
| Filter | Changing what data is shown | CALCULATE, FILTER, ALL |
| Date and Time | Working with dates | TODAY, YEAR, DATEADD |
| Time Intelligence | Comparing data across time periods | TOTALYTD, SAMEPERIODLASTYEAR |
| Text | Working with text values | CONCATENATE, LEFT, UPPER |
| Logical | Checking conditions | IF, AND, OR, SWITCH |
| Table | Building or changing tables | SUMMARIZE, ADDCOLUMNS |
| Relationship | Working with related tables | RELATED, RELATEDTABLE |
Basic DAX Interview Questions and Answers
These questions are asked to check if you understand what DAX is and how it is used.
1. What does DAX stand for?
DAX stands for Data Analysis Expressions. It is the formula language used inside Power BI to build measures and calculated columns.
2. Where is DAX used?
DAX is used in Power BI, Excel Power Pivot, and SQL Server Analysis Services. It works the same way across all three tools.
3. What can you build using DAX?
You can build three main things with DAX: measures, calculated columns, and calculated tables. Each one is used for a different purpose in a report.
4. Is DAX a programming language?
DAX is a formula language, not a full programming language like Python or C#. It does not have loops or variables in the same way, but it does support its own logic using functions and variables.
5. What is the basic structure of a DAX formula?
A DAX formula starts with a name, followed by an equal sign, and then an expression. For example, Total Sales = SUM(Sales[Amount]) is a simple DAX measure.
6. What is a measure in DAX?
A measure is a formula that calculates a result, like a total or an average, at the time a report is viewed. It is not stored in the table and changes based on filters.
7. What is a calculated column in DAX?
A calculated column is a new column added to a table using a DAX formula. Unlike a measure, it is calculated once for each row and then stored in the data model.
8. What is a calculated table?
A calculated table is a new table created using a DAX formula instead of importing it from a data source. It is often used to build helper tables, like a date table.
9. Can DAX formulas refer to other tables?
Yes. DAX formulas can use data from other tables as long as those tables are connected through a relationship in the data model.
10. Why is DAX important for a Power BI job?
DAX is important because it powers almost every calculation in a Power BI report. Without DAX, you cannot build measures, KPIs, or many advanced visuals.
DAX Syntax and Operators Interview Questions
These questions test how well you know the basic rules and symbols used when writing DAX code.
11. What are the main parts of DAX syntax?
A DAX formula has a name, an equal sign, and a function or expression. It can also use table names, column names, and operators inside brackets and parentheses.
12. How do you refer to a column in DAX?
You write the table name followed by the column name in square brackets, like Sales[Amount]. This tells DAX exactly which table and column to use.
13. What are the common operators used in DAX?
DAX supports math operators like plus and minus, comparison operators like equal to and greater than, and logical operators like AND and OR.
14. What is the difference between a function and an operator in DAX?
A function, like SUM or IF, performs a set task and needs input values inside parentheses. An operator, like plus or equal to, works directly between two values without parentheses.
15. How do you write comments in DAX?
You can write a single line comment using two forward slashes, like // this is a comment. For multiple lines, you can use /* at the start and */ at the end.
16. Is DAX case sensitive?
No. DAX is not case sensitive for function names and table names. SUM, sum, and Sum will all work the same way, though it is common practice to write function names in capital letters.
17. What is the correct way to write a simple DAX measure?
A simple measure follows this pattern: MeasureName = Function(Table[Column]). Here is an example:
Total Sales = SUM(Sales[SalesAmount])
18. How do you write an IF condition in DAX?
You use the IF function with three parts: the condition, the result if true, and the result if false. Here is an example:
Sales Status = IF(SUM(Sales[SalesAmount]) > 10000, “High”, “Low”)
19. What is nesting in DAX?
Nesting means placing one function inside another function. For example, using CALCULATE inside a FILTER, or an IF inside another IF.
20. What is the ampersand (&) used for in DAX?
The ampersand is used to join, or combine, two text values together. It works like the CONCATENATE function.
Row Context and Filter Context Interview Questions
Context is one of the trickiest DAX topics in interviews. These questions check if you truly understand how DAX calculates values.
21. What is context in DAX?
Context is the setting under which a DAX formula is calculated. It decides which rows of data are used at any given moment. There are two main types: row context and filter context.
22. What is row context?
Row context means DAX is looking at one row at a time. This happens naturally inside calculated columns and inside iterator functions like SUMX.
23. What is filter context?
Filter context means DAX is looking at a group of rows based on filters, slicers, or the fields used in a visual. This is common inside measures.
24. How does CALCULATE change filter context?
CALCULATE lets you add, remove, or change filters before a calculation runs. Here is an example that finds sales only for the year 2026:
Sales 2026 = CALCULATE(SUM(Sales[SalesAmount]), Sales[Year] = 2026)
25. What is context transition?
Context transition happens when row context is turned into filter context. This usually happens when CALCULATE is used inside a calculated column or an iterator function.
26. What is the ALL function used for?
The ALL function removes filters from a table or column. It is often used to calculate a grand total that ignores filters used in a visual.
Total Sales All = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales))
27. What is the difference between ALL and ALLEXCEPT?
ALL removes every filter from a table. ALLEXCEPT removes all filters except the ones you choose to keep. This gives you more control over which filters stay active.
28. What is an iterator function?
An iterator function, like SUMX or AVERAGEX, goes row by row through a table and runs a calculation on each row. It then combines the results at the end.
Total Value = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])
29. Why do measures depend on filter context?
Measures are built to react to filters, slicers, and the rows and columns in a visual. This is why the same measure can show different numbers on different parts of a report.
30. What is the difference between EARLIER and VAR in handling row context?
EARLIER is an older function that lets you access an outer row context from inside a nested calculation. VAR is a newer and simpler way to store a value and avoid the confusion that EARLIER can cause.
DAX Functions Interview Questions with Examples
This section covers common DAX functions that show up in almost every interview. Each answer includes a short code example.
31. What does the SUM function do?
SUM adds up every value in a column. Here is a simple example:
Total Quantity = SUM(Sales[Quantity])
32. What does the AVERAGE function do?
AVERAGE finds the average, or mean, of the values in a column. Example:
Average Price = AVERAGE(Sales[UnitPrice])
33. What does the COUNTROWS function do?
COUNTROWS counts the number of rows in a table. It is often used to count how many orders or transactions exist.
Order Count = COUNTROWS(Sales)
34. What does the DISTINCTCOUNT function do?
DISTINCTCOUNT counts the number of unique values in a column, ignoring duplicates. It is useful for counting unique customers or products.
Unique Customers = DISTINCTCOUNT(Sales[CustomerID])
35. What does the FILTER function do?
FILTER returns a smaller table that only includes rows matching a condition. It is often used inside CALCULATE.
High Sales = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[SalesAmount] > 1000))
36. What does the RELATED function do?
RELATED pulls a value from a related table when a relationship already exists. It works when moving from the many side to the one side of the relationship.
Product Category = RELATED(Product[Category])
37. What does the SWITCH function do?
SWITCH checks a value against several possible results and returns the first match. It is often used instead of writing many nested IF statements.
Sales Tier = SWITCH(TRUE(), Sales[SalesAmount] > 10000, “Gold”, Sales[SalesAmount] > 5000, “Silver”, “Bronze”)
38. What does the DIVIDE function do?
DIVIDE performs division and safely handles errors, like dividing by zero. It is safer than using a normal division sign.
Profit Margin = DIVIDE(SUM(Sales[Profit]), SUM(Sales[SalesAmount]), 0)
39. What does the CONCATENATE function do?
CONCATENATE joins two text values into one. Many people now use the ampersand symbol instead, since it is shorter to write.
Full Name = CONCATENATE(Customer[FirstName], Customer[LastName])
40. What does the RANKX function do?
RANKX gives a rank number to each row based on a value, such as ranking products by total sales. It is useful for top performer reports.
Sales Rank = RANKX(ALL(Product), SUM(Sales[SalesAmount]))
Time Intelligence and Advanced DAX Interview Questions
These questions cover date comparisons and more advanced DAX topics that come up in senior or experienced level interviews.
41. What is time intelligence in DAX?
Time intelligence functions help you compare values across different time periods, such as this month versus last month, or this year versus last year.
42. What does the TOTALYTD function do?
TOTALYTD calculates a running total from the start of the year up to the current date in the report. Example:
Sales YTD = TOTALYTD(SUM(Sales[SalesAmount]), ‘Date'[Date])
43. What does the SAMEPERIODLASTYEAR function do?
SAMEPERIODLASTYEAR shifts the current dates back by one year, so you can compare this year’s numbers with last year’s numbers.
Sales LY = CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(‘Date'[Date]))
44. What is the requirement for time intelligence functions to work correctly?
You need a proper date table marked as a date table in Power BI, with a continuous list of dates and no gaps. Without this, time intelligence functions can give wrong results.
45. What is the difference between DATESYTD and TOTALYTD?
DATESYTD returns a table of dates from the start of the year to the current date. TOTALYTD is a shortcut function that combines DATESYTD with an aggregation like SUM in one step.
46. What are variables (VAR) in DAX and why are they useful?
Variables let you store the result of a calculation and reuse it later in the same formula. They make formulas easier to read and can also improve performance.
Profit % =
VAR TotalSales = SUM(Sales[SalesAmount])
VAR TotalProfit = SUM(Sales[Profit])
RETURN DIVIDE(TotalProfit, TotalSales, 0)
47. What is the difference between calculated columns and measures in terms of performance?
Calculated columns are stored in memory and can make the file size bigger, but they are ready to use instantly. Measures are calculated at report time, which saves storage space but uses more processing power when the report is viewed.
48. What is the ALLSELECTED function used for?
ALLSELECTED removes filters that come from inside the visual, like row and column headers, but keeps filters from slicers and page filters outside the visual. It is often used for percentage of total calculations.
49. How can you improve the performance of slow DAX formulas?
You can improve performance by using variables to avoid repeating calculations, avoiding row-by-row calculations on large tables when possible, and using simple filters instead of complex nested functions.
50. What is a common mistake beginners make with DAX?
A common mistake is confusing calculated columns with measures, or not understanding filter context. Many beginners also write overly complex formulas instead of breaking them into smaller variables.
Common DAX Operators
Here is a quick reference table of operators you may need to explain in an interview.
| Operator | Meaning | Example |
| + | Addition | Sales[Qty] + 1 |
| – | Subtraction | Sales[Qty] – 1 |
| * | Multiplication | Sales[Qty] * Sales[Price] |
| / | Division | Sales[Total] / Sales[Qty] |
| = | Equal to | Sales[Year] = 2026 |
| > | Greater than | Sales[Amount] > 1000 |
| & | Join text values | [First] & ” ” & [Last] |
| && | Logical AND | [A] > 1 && [B] > 1 |
Tips to Prepare for a DAX Interview
- Practice writing simple measures like SUM, AVERAGE, and COUNTROWS by hand
- Learn the difference between row context and filter context with real examples
- Get comfortable using CALCULATE, since it comes up in almost every interview
- Build a small date table and try time intelligence functions like TOTALYTD
- Use variables (VAR) in your formulas to keep them clean and easy to explain
- Explain your DAX answers out loud, as if teaching someone else
Frequently Asked Questions
Is DAX hard to learn?
DAX can feel hard at first, mainly because of row context and filter context. With regular practice on real data, most people become comfortable within a few weeks.
Do I need to memorize every DAX function for an interview?
No. It is more important to understand common functions like SUM, CALCULATE, FILTER, and time intelligence functions. You can always look up rare functions later on the job.
Is DAX similar to Excel formulas?
DAX looks similar to Excel formulas, but it works with full tables and columns instead of single cells. This makes DAX more powerful for large data sets.
Final Thoughts
This list of 50 Power BI DAX interview questions and answers covers the basics, syntax, context, common functions, and time intelligence. Practice writing these formulas yourself instead of just reading them, since hands-on practice is the best way to remember DAX.
Try to build a small sample report with real or sample data. Add a few measures using the functions covered in this article. This will make you much more confident walking into your next Power BI interview.
