Bird
0
0

Identify the error in this DAX expression:

medium📝 Formula Fix Q6 of 15
Power BI - Power Query Editor

Identify the error in this DAX expression:
FILTER(Sales, Sales[Amount] => 500)

AThe operator '=>' is invalid; should be '>='
BMissing table name before Amount
CFILTER cannot be used with numeric columns
DThe expression is correct
Step-by-Step Solution
Solution:
  1. Step 1: Check operator syntax

    '=>' is not a valid comparison operator in DAX.
  2. Step 2: Correct operator usage

    The correct operator for 'greater than or equal' is '>='.
  3. Final Answer:

    The operator '=>' is invalid; should be '>=' -> Option A
  4. Quick Check:

    Use >= for greater or equal in DAX [OK]
Quick Trick: Use >=, not =>, for greater or equal [OK]
Common Mistakes:
  • Typing => instead of >=
  • Omitting table name in column reference
  • Thinking FILTER can't use numeric columns

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes