DAX Error using the "&&" or the "and"

[Rena]

I am running into an issue with the formula listed below. I tried the "&&" instead of the "and"  but i have the same results (error) when validating my formula.

Can you please help me manage this?

[BeaBF]

@Rena In the Power Query language M you have to use only one ampersand -> &

It works?

B.

[Rena]

it was not that the problem but the if clause.

[VahidDM · Accepted solution]

Hi @Rena 

This is MCODE in Power Query, and it's not Dax to use &&.

https://docs.microsoft.com/en-us/powerquery-m/m-spec-conditionals

Don't use else for all IF statements; write IF then else IF then else IF then else ,,,

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

Appreciate your Kudos✌️!!

[Rena]

Thank you. It works