Power BI - Power Query Editor
Which of the following is the correct syntax to filter a table Sales for rows where Amount is greater than 100?
FILTER(____, Amount > 100)Which of the following is the correct syntax to filter a table Sales for rows where Amount is greater than 100?
easy📝 Formula Fix Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the table argument in FILTER
The first argument of FILTER is the table to filter, here it should be 'Sales'.Step 2: Confirm the condition syntax
The condition 'Amount > 100' is correct, so the missing part is the table name 'Sales'.Final Answer:
Sales -> Option BQuick Check:
FILTER(table, condition) needs table = A [OK]
Quick Trick: First argument in FILTER is the table name [OK]
Common Mistakes:
- Using column name instead of table
- Putting FILTER as first argument
- Using a number instead of table
Master "Power Query Editor" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes