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 using conditional columns, wheras the if statement works just fine when I create my own code.

 

Thanks,

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.

2 Replies

  • 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.