Custom Column with nested SUMIF RRS feed

  • Question

  • Hi,

    I am trying to replicate an excel formula in Power Query but can't get the SUMIF portion to work but I don't know the comparative formula in M.

    This what I am trying to replicate:


    This is as far as I got (no laughing):

    if(Text.Contains[Order Number] ) then ([Payment Amount] - CALCULATE(SUM([Paid amount currency]), FILTER([Payment]=[Payment]))) else ""

    I don't get a syntax error but it return expression error for calculate...I'm so confused as I got expression error with sumif too.  I am fine in excel but trying to teach myself using google!!

    Sunday, February 17, 2019 7:07 PM