🔥 Power BI Interview Q&A ( Frequently Asked 🔥)

📊 Q1. What is the difference between a calculated column and a measure?

👉 Calculated Column → Row-level, stored in memory
👉 Measure → Aggregated, calculated on the fly
👉 Use measures for performance & dynamic analysis

📊 Q2. What is a star schema and why is it important?

👉 Central fact table + surrounding dimension tables
👉 Improves performance & scalability
👉 Makes DAX simpler and more efficient

📊 Q3. What are filter context and row context in DAX?

👉 Row Context → Works at individual row level
👉 Filter Context → Applies filters across data
👉 Understanding both is key to writing correct DAX

📊 Q4. What is the use of CALCULATE() in Power BI?

👉 Modifies filter context
👉 Used for advanced calculations
👉 Core function for most complex DAX logic

📊 Q5. How do you handle missing or null values in Power BI?

👉 Use Power Query (Replace / Fill options)
👉 Handle with DAX (COALESCE, IF)
👉 Ensure clean data before building visuals

🔥 React with ♥️ for more such questions