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
Bookmarks