Power BI Data Modeling & DAX Questions

Understand Power BI's data modeling concepts: relationships (one-to-many, many-to-many), cardinality, filter propagation, and bidirectional relationships. Write DAX formulas for measures and calculated columns, including basic (SUM, COUNT, AVERAGE) and advanced functions (CALCULATE, FILTER, ALL, VALUES). Understand variables and performance implications of DAX formulas.

EasySystem Design

0 practiced

Explain why a star schema is recommended for Power BI models. Provide a small example schema for sales analysis listing a fact table and appropriate dimension tables, and explain how this design influences DAX measure simplicity and performance.

EasyTechnical

0 practiced

Explain row context versus filter context in DAX. Provide an example describing how a calculated column uses row context, how CALCULATE can transform row context into filter context, and mention a case where this context transition changes results unexpectedly.

MediumTechnical

0 practiced

Write a DAX measure to compute month-over-month percentage change in Sales Amount. Model: Sales(Date, Amount) and Calendar(Date). The measure should handle the case where the previous month has zero sales by using safe division. Provide the DAX using PREVIOUSMONTH or DATEADD and DIVIDE.

MediumTechnical

0 practiced

Write a DAX measure to compute weighted average price per product category using SUMX. Model: Sales(ProductID, Quantity, UnitPrice), Product(ProductID, Category). Provide the DAX expression (in DAX) and explain why SUMX is required.

MediumSystem Design

0 practiced

You have Sales(OrderDate, ShipDate, OrderID) and Calendar(Date, IsHoliday). Design the data model and write a DAX measure to compute average days to ship excluding weekends and holidays. Describe which relationships you would use and how USERELATIONSHIP factors into the measure.

Unlock Full Question Bank

Get access to hundreds of Power BI Data Modeling & DAX interview questions and detailed answers.

Join thousands of developers preparing for their dream job.