📊 Power BI Interview Q&A You Must Know 💡

1️⃣ What is the difference between a calculated column and a measure in Power BI?

✅ Calculated Column → Computed row by row and stored in the model

✅ Measure → Calculated dynamically based on filters and visuals

2️⃣ What is DAX in Power BI?

✅ DAX (Data Analysis Expressions) is the formula language used in Power BI for calculations and data analysis.

📌 Used for:
• Measures
• Calculated Columns
• Calculated Tables

3️⃣ What is the difference between Import Mode and DirectQuery?

✅ Import Mode → Loads data into Power BI for faster performance

✅ DirectQuery → Queries data directly from the source in real time

💡 Import is faster, DirectQuery is useful for huge/live datasets.

4️⃣ What are relationships in Power BI?

✅ Relationships connect tables using common columns.

📌 Types:
• One-to-One
• One-to-Many
• Many-to-Many

💡 Correct relationships are essential for accurate reports.

5️⃣ What is the use of Power Query?

✅ Power Query is used for:
• Cleaning data
• Transforming data
• Removing duplicates
• Merging tables
• Automating preprocessing steps

💡 Most real-world BI projects spend major time in data cleaning.

React ♥️ for more interview questions