Power BI - Getting Data
If you import an Excel table named 'SalesData' and want to filter rows where Region equals 'West', which Power Query step is correct?
If you import an Excel table named 'SalesData' and want to filter rows where Region equals 'West', which Power Query step is correct?
medium📝 Formula Result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Identify filtering action
Filtering rows by a condition is done using Filter Rows in Power Query Editor.Step 2: Exclude other actions
Remove Columns deletes columns, Sort Rows orders data, Add Column creates new columns but does not filter.Final Answer:
Filter Rows > Region equals 'West' -> Option DQuick Check:
Filter rows by condition = Filter Rows > Region equals 'West' [OK]
Quick Trick: Use Filter Rows to keep only desired data [OK]
Common Mistakes:
- Removing columns instead of filtering rows
- Sorting data instead of filtering
- Adding columns instead of filtering
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes