Forum Discussion
Solved
M code query
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)...
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
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