Forum Discussion

Stemar_Aubert's avatar
Stemar_Aubert
Resolver I
6 years ago
Solved

Each if VS if alone

Hello everyone,   I have a bit of a naive question, and can't find anything on this topic online.   What is the difference between the each if and if ? I've only seen the each if appear when usin...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Sauber,

    You need to understand the "each" syntax in M code, it will be used to  find all records in corresponding column which meet the condition. You could refer to The Each Keyword in Power Query and Understanding Power Query M functions for detail. This is used in M code

    And when you create measure , you will use if syntax , this is used in DAX.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi Sauber,

You need to understand the "each" syntax in M code, it will be used to  find all records in corresponding column which meet the condition. You could refer to The Each Keyword in Power Query and Understanding Power Query M functions for detail. This is used in M code

And when you create measure , you will use if syntax , this is used in DAX.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Stemar_Aubert's avatar
    Stemar_Aubert
    Resolver I
    6 years ago

    Thank you for helping!