Power BI — Quick Reference Cheatsheet
Essential Formulas & Rules
Core Topics
Core Power BI Topic 1:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 1
Core Power BI Topic 2:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 2
Core Power BI Topic 3:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 3
Core Power BI Topic 4:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 4
Core Power BI Topic 5:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 5
Core Power BI Topic 6:
Key formula/rule: See fundamentals section for complete derivation
When to apply: When the problem mentions keywords related to core power bi topic 6
Problem-Solving Templates
Template 1: Identify → Apply → Verify
Template 2: For MCQs
Most Common Question Types
| Type | What to Do | Time Budget |
|---|
|---|---|---|
| Direct formula | Apply formula directly | 30-60 sec |
|---|---|---|
| Multi-step | Break into steps, apply each | 1-2 min |
| Concept-based | Recall definition + example | 45 sec |
| Data interpretation | Extract data, compute | 2-3 min |
Revision Strategy
1 month before exam:
1 week before:
1 day before:
Labs Section
The Labs section for Power BI has: