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.

HardTechnical

0 practiced

You have multiple inactive date relationships in a fact table: OrderDate, ShipDate, InvoiceDate. Users should pick which date drives the report via a single slicer. Propose a pattern using a disconnected DateRole table or DateRole selector and provide example DAX measures that use USERELATIONSHIP or TREATAS to switch the active date. Discuss performance implications.

EasyTechnical

0 practiced

Describe the purpose of USERELATIONSHIP in DAX. You have Sales(OrderDate, ShipDate, OrderID) and Calendar(Date). Without changing model relationships, explain how you would write a DAX measure to compute total sales by ShipDate using an inactive relationship and USERELATIONSHIP.

MediumTechnical

0 practiced

Describe how to implement incremental refresh in Power BI for a Sales table with very large history. Include the required Power Query parameters (RangeStart and RangeEnd), partitioning considerations, and explain how DAX measures may be impacted by partitioned data.

MediumSystem Design

0 practiced

You must allow users to slice reports by either Order Date or Ship Date simultaneously while preserving correct measures. Propose a data model and DAX pattern that supports both slicers without duplicating measures, mentioning disconnected slicers, USERELATIONSHIP, SWITCH logic, or TREATAS where appropriate.

MediumTechnical

0 practiced

Explain ALLEXCEPT in DAX and how it differs from ALL and ALLSELECTED. Provide a clear example where you remove filters on all columns of the Product table except Product[Category] so that totals are calculated at category level regardless of product selection.

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.