Hello Everyone,

Can anyone translate this formula in Power Query? What do you call it in power query syntax or formulas? whatever it is I badly needed your HELP peeps!!!

=IF(All_EARLY_EDRMS_Log[@[Received From (KEO)]]<>"","KEO Submited to JV",IF(All_EARLY_EDRMS_Log[@Initiator]="KEO","KEO to Submit","Not Required"))


I created a custom column in power query with below formula/syntax:

IF([#"Received From (KEO)"]<>"","KEO Submited to JV",IF([Initiator]="KEO","KEO to Submit","Not Required")) - "No syntax errors have been detected" then when I click Okay

I'm getting this error "Expression.Error: The name 'IF' wasn't recognized. Make Sure it's spelled correctly.

= Table.AddColumn(#"Reordered Columns1", "KEO to JV", each IF([#"Received From (KEO)"]<>"","KEO Submited to JV",IF([Initiator]="KEO","KEO to Submit","Not Required")))

Thanks,
Edward