*Some complex scenario-based Power BI interview questions asked in top MNCs:* *1. Complex Data Modeling with Mixed Granularity:* Scenario: You’re given three datasets — daily transaction data, weekly inventory levels, and monthly financial targets. Your task is to build a unified Power BI dashboard that compares actuals against targets while also showing stock availability trends. Discuss: The challenges posed by varying levels of granularity. How you'd use composite models, data aggregation, and calculated tables/measures to create meaningful visuals. When and how to use DAX functions like SUMX, AVERAGEX, and CALCULATE with FILTER to control the evaluation context. *Key Focus: Data Modeling, DAX, Aggregation, Relationships, Star Schema.* *2. Dynamic Row-Level Security (RLS) Based on User Hierarchies:* Scenario: A multinational company needs a dashboard where managers can only see the data of their respective teams, while regional heads can view data for their entire region. Discuss: How to implement dynamic RLS using DAX and user-based filtering. How you’d manage security roles when hierarchies vary across departments. The performance implications and best practices for managing RLS in large datasets. *Key Focus: Row-Level Security, DAX USERNAME(), Roles, Hierarchical Filtering.* *3. Advanced Time Intelligence with Custom Fiscal Calendar:* Scenario: You are asked to analyze sales trends using a custom fiscal year that starts in July and ends in June. The dashboard must include YoY, QoQ, MoM metrics, rolling averages, and fiscal period comparisons. Discuss: How to build a custom date table and create measures for fiscal time comparisons. How to handle time intelligence functions like SAMEPERIODLASTYEAR, DATEADD, DATESYTD, and PREVIOUSMONTH with a non-standard calendar. How to ensure slicers and visuals sync across time levels. *Key Focus: Time Intelligence, Custom Date Tables, DAX Measures, Fiscal Year Logic.* Hope you'll like it Like this post if you need more content like this 👍❤️