Forum Discussion

Hennie7863's avatar
Hennie7863
Frequent Visitor
11 years ago
Solved

The formula is incomplete

HI I'm trying to follow the tutorial : https://support.powerbi.com/knowledgebase/articles/471597 and I'm getting the error that the formula is incomplete....

 

It is in the Add custom column window and it happens when i drag one field in the window.

 

[Order_Details.UnitPrice]

 

for instance....really frustrating that I'm keep getting this error.

 

Can someone help me with this???

 

 

  • HarrisMalik's avatar
    HarrisMalik
    11 years ago

    It should start with "=" operator. Can you share a screenshot?

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hennie,

    I just walked through the tutorial with no issues...

    The only thing I didn't see explicitly stated that I did prior to loading the Orders data set was to select the "close and load" to save that prior to loading the next data set ... are you forgetting the ' *  ' between the two fields?

    Can you reply with the actual formula that you are inputting?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Do you have an "=" in front of it:

     

    Formula should be:

     

    =[Orders.Detail...

    • HarrisMalik's avatar
      HarrisMalik
      Continued Contributor

      It should start with "=" operator. Can you share a screenshot?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi HarrisMalik,

         

        your formula should be:                              LineTotal = [Order_Details.UnitPrice] * [Order_Details.Quantity]

        Is it like this?