+ Reply to Thread
Results 1 to 3 of 3

Power Query Formula/Syntax

  1. #1
    Registered User
    Join Date
    07-02-2011
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    10

    Power Query Formula/Syntax

    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

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Power Query Formula/Syntax

    Note that in PowerQuery "M" function, case is very important.

    Syntax for IF function.
    Please Login or Register  to view this content.
    For your formula it would be something like...
    Please Login or Register  to view this content.
    Last edited by CK76; 04-06-2017 at 08:50 AM.

  3. #3
    Registered User
    Join Date
    07-02-2011
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Power Query Formula/Syntax

    Thanks CK76!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. How do I get my formula to work in a power query
    By Justair07 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2016, 10:34 AM
  3. Help with Power Query Custom Column Formula
    By travis.cook21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-16-2016, 01:45 PM
  4. [SOLVED] Formula Creation with Power Query
    By Bhalbert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2016, 01:11 PM
  5. [SOLVED] Is there a way to add a normal excel formula to a Power Query Table
    By beaglesBuddy in forum Excel General
    Replies: 1
    Last Post: 07-09-2016, 04:30 PM
  6. Formula Syntax Query - Excell 2010
    By Matt_Cox in forum Excel General
    Replies: 7
    Last Post: 07-29-2010, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1