M code query

[FranckGbadamass]

Hi,

I'm try to rewrite this excel formula into Power Query, the fields are the same.

=IF(OR((IF(AND([@[First_Repymt_Date]]<[@[Date_Valid]];[@[Date_Valid]]<[@[h_3]];[@[Unpaid_Installment_Count]]>=3);1;0)=1);F2="Y");1;0)

1. What I've done in Power Query custom column

as I'm not familiar with M language I dont know why the formula doesn't shows me the expected value.

        2.   The formula result

Any help will be appreciated.

Thanks

[mahoneypat · Accepted solution]

Please try this syntax instead, or try wrapping your first if...then...else in parentheses (if ... then ... else ) = 1 then ...

= if [a]>[b] and [c]>[d] and [d] > 3 then 1 else if [e] = "Y" then 1 else 0

Pat