none
the formula is incomplete RRS feed

  • Question

  • Hi,

    working with Power BI desktop and I'm trying to add a column in the query designer and I'm keep getting this error: "the formula is incomplete". 

    The formula : [Order_Details.UnitPrice]*[Order_Details.Quantity]

    This is the tutorial that I'm trying to follow: https://support.powerbi.com/knowledgebase/articles/471597


    • Edited by Hennie7863 Tuesday, July 28, 2015 1:37 PM
    Tuesday, July 28, 2015 1:36 PM

Answers

  • Are you getting the "formula is incomplete" error when attempting to commit the new column, or after it's committed? If you could right-click on the query, open the advanced editor, and copy/paste all your steps into this thread that would also help folks figure out what might be going on.

    Thanks,

    Ehren

    Friday, July 31, 2015 10:10 PM
    Owner

All replies

  • Did you put "=" in front,

    =[Order_Details.UnitPrice]*[Order_Details.Quantity]


    Tuesday, July 28, 2015 3:29 PM
  • Yes the = is already there..and cannot be deleted..

    Its default with = (then the formula is correct)

    When I delete the complete line again back to the = an error happens... Now the OK button is never enabled...

    Tuesday, July 28, 2015 5:11 PM
  • Are you getting the "formula is incomplete" error when attempting to commit the new column, or after it's committed? If you could right-click on the query, open the advanced editor, and copy/paste all your steps into this thread that would also help folks figure out what might be going on.

    Thanks,

    Ehren

    Friday, July 31, 2015 10:10 PM
    Owner