Each if VS if alone

[Stemar_Aubert]

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,

[dax · Accepted solution]

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]

Thank you for helping!