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...
  • HarrisMalik's avatar
    HarrisMalik
    11 years ago

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

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

 

Formula should be:

 

=[Orders.Detail...

  • HarrisMalik's avatar
    HarrisMalik
    Icon for Continued Contributor rankContinued Contributor
    11 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi HarrisMalik,

       

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

      Is it like this?

      • HarrisMalik's avatar
        HarrisMalik
        Icon for Continued Contributor rankContinued Contributor
        10 years ago

        Anonymous Yes it is correct. Here LineTotal is the name of calcuated column