Power BI interview questions: answers with DAX examples
Data modeling, DAX and the Power BI service, explained in plain words with the measures interviewers ask you to read and write.
Power BI interviews cover three layers: getting and shaping data (Power Query), modeling it (star schemas, relationships, a date table) and calculating with DAX (measures, CALCULATE, filter and row context, time intelligence), plus the Power BI service: refresh, gateways, workspaces, apps and row-level security. Below are 19 questions from basic to advanced with short answers and DAX examples.
Basic power bi interview questions
Basic1. What are the main parts of Power BI?
Power BI Desktop is where you connect to data, shape it in Power Query, model it and build reports. The Power BI service (in the browser) is where reports are published, shared, refreshed and secured, in workspaces and apps. Mobile apps view the same content.
Basic2. What is the difference between Power Query and DAX?
Power Query (the M language) extracts and transforms data before it is loaded: removing columns, merging tables, changing types. DAX calculates on the loaded model: measures and calculated columns that respond to filters in reports. Shape data as early as possible in Power Query, calculate in DAX.
Basic3. What is a star schema, and why does Power BI prefer it?
A star schema has fact tables (events such as sales, with numeric columns and keys) surrounded by dimension tables (who, what, when: customer, product, date). Filters flow from dimensions to facts through one-to-many relationships, which keeps DAX simpler and the model faster than one wide flat table.
Basic4. What is the difference between a calculated column and a measure?
A calculated column is computed row by row when data refreshes and stored in the model, so it uses memory and can be used in slicers. A measure is computed at query time in the current filter context and is not stored; use measures for totals, ratios and anything that should respond to filters.
DAX · Example (not executed)-- calculated column on Sales: stored per row
Line Amount = Sales[Quantity] * Sales[Unit Price]
-- measure: computed for whatever the visual is filtered to
Total Sales = SUM ( Sales[Line Amount] )Basic5. What do relationship cardinality and cross-filter direction mean?
Cardinality says how rows match: one-to-many (the normal dimension to fact link), one-to-one or many-to-many. Cross-filter direction says which way filters flow: single (from the one side to the many side) is the safe default; both directions can be needed but can create ambiguity and slow the model.
Basic6. Why do you need a date table?
Time intelligence functions need a continuous date table with one row per day and no gaps, marked as a date table and related to the fact table's date column. It also gives you columns such as year, quarter, month and fiscal periods to slice by.
Intermediate power bi interview questions
Intermediate7. What does CALCULATE do?
CALCULATE evaluates an expression in a modified filter context: it adds, replaces or removes filters before calculating. It is the most important DAX function because it is how you write measures such as sales for one region or sales for last year.
DAX · Example (not executed)West Sales = CALCULATE ( [Total Sales], Region[Region] = "West" )
All-Region Sales = CALCULATE ( [Total Sales], REMOVEFILTERS ( Region ) )
Share of All Regions = DIVIDE ( [Total Sales], [All-Region Sales] )Intermediate8. What is the difference between row context and filter context?
Row context means 'the current row', and exists in calculated columns and iterators such as SUMX. Filter context is the set of filters from the visual, slicers and CALCULATE that decides which rows a measure sees. CALCULATE inside a row context turns the row into a filter (context transition).
Intermediate9. When do you use SUMX instead of SUM?
SUM adds one column. SUMX iterates over a table and adds the result of an expression evaluated for each row, so you can multiply columns without storing a calculated column. Other iterators (AVERAGEX, MAXX, COUNTX) work the same way.
DAX · Example (not executed)Revenue = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] )Intermediate10. Why use DIVIDE instead of the / operator?
DIVIDE handles division by zero or blank by returning blank (or an alternate result you pass), so visuals do not show errors and the code reads clearly.
DAX · Example (not executed)Margin % = DIVIDE ( [Total Sales] - [Total Cost], [Total Sales] )Intermediate11. How do you write year-to-date and prior-year measures?
With a marked date table, TOTALYTD (or CALCULATE with DATESYTD) gives year-to-date, and SAMEPERIODLASTYEAR shifts the filter one year back so you can compare periods.
DAX · Example (not executed)Sales YTD = TOTALYTD ( [Total Sales], 'Date'[Date] )
Sales PY = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
YoY % = DIVIDE ( [Total Sales] - [Sales PY], [Sales PY] )Intermediate12. What is the difference between ALL, ALLEXCEPT and REMOVEFILTERS?
ALL returns a table or column ignoring filters, and as a CALCULATE modifier removes filters. REMOVEFILTERS only removes filters, which reads more clearly in CALCULATE. ALLEXCEPT removes filters from a table except on the columns you list, for example to get a total per category regardless of other filters.
Intermediate13. What is the difference between Import, DirectQuery and composite models?
Import loads data into Power BI's in-memory engine: fastest queries, but data is as fresh as the last refresh. DirectQuery sends queries to the source each time: fresh data, but slower and limited by the source. Composite models mix both, for example importing dimensions and querying a large fact table directly.
Intermediate14. What is row-level security?
RLS restricts which rows a user can see. You define roles with DAX filters in Desktop, such as a region equal to the user's region (often using USERPRINCIPALNAME and a mapping table), then assign users or groups to roles in the service. It applies to viewers, not to workspace members with edit rights.
DAX · Example (not executed)-- role filter on the Region table
[Manager Email] = USERPRINCIPALNAME ()Advanced power bi interview questions
Advanced15. How do you make a slow report faster?
Use Performance Analyzer to find slow visuals and DAX queries, reduce model size (remove unused columns, lower cardinality, use proper data types), prefer measures to calculated columns, avoid bidirectional filters you do not need, reduce the number of visuals per page and push transformations upstream.
Advanced16. What is a gateway, and when do you need one?
An on-premises data gateway lets the Power BI service refresh or query data sources inside a private network, such as an on-premises SQL Server. Cloud sources reachable from the internet usually do not need one.
Advanced17. What is the difference between RELATED and RELATEDTABLE?
RELATED fetches one value from the 'one' side of a relationship while you are on the 'many' side (for example the product category on a sales row). RELATEDTABLE returns the rows on the 'many' side for the current row on the 'one' side, so you can count or sum them.
DAX · Example (not executed)-- calculated column on Sales
Category = RELATED ( Product[Category] )
-- calculated column on Product
Order Lines = COUNTROWS ( RELATEDTABLE ( Sales ) )Advanced18. How do you share Power BI content with an organization?
Publish to a workspace for collaboration, then distribute with an app (a packaged, read-only view for an audience), share individual reports, or embed them. Licensing and capacity decide who can view; sensitivity labels and RLS control what they see.
Advanced19. How do you explain a dashboard you built?
Start with the audience and the decision it supports, then the data sources and model, the key measures and how you validated them against the source, design choices that made it usable, and what changed because of it.
How to practice with this page
- Build a small star schema (a sales fact table, date, product and customer dimensions) and write each measure here against it.
- Explain filter context out loud with one visual and one slicer.
- Use Performance Analyzer on a slow report and say what you would change.
- Be ready to walk through one dashboard you built: audience, decisions, design.
Related interview prep
Disclosure: TryHired makes HIRED, a paid job-search program, so we have a conflict of interest when we mention it. This question bank is free, with no TryHired signup.
Questions people ask
What Power BI questions are asked in interviews?
How much DAX do I need for a Power BI interview?
Is there a Power BI certification?
Do Power BI interviews include SQL?
Power BI or Tableau: which should I learn?
How this page is built
TryHired wrote these questions and answers. Blocks marked Example (not executed) are configuration, commands or formulas that cannot run on the build machine: no output is claimed for them. The question list is general practice: it does not predict what a particular employer will ask.
- Interviewers ask different questions for different roles and levels.
- Answers are short explanations, not complete references.
- Power BI changes monthly; menu names and licensing details move.
- DAX examples assume a sample model (Sales, Date, Product tables) described in the text.
- Microsoft Learn, DAX overview: https://learn.microsoft.com/en-us/dax/dax-overview
- Microsoft Learn, CALCULATE function: https://learn.microsoft.com/en-us/dax/calculate-function-dax
- Microsoft Learn, star schema and Power BI: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
- Microsoft Learn, row-level security with Power BI: https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security