Forum Discussion
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);1;0)=1);F2="Y");1;0)
- 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
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
1 Reply
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