Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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???
Solved! Go to Solution.
It should start with "=" operator. Can you share a screenshot?
Do you have an "=" in front of it:
Formula should be:
=[Orders.Detail...
It should start with "=" operator. Can you share a screenshot?
Hi HarrisMalik,
your formula should be: LineTotal = [Order_Details.UnitPrice] * [Order_Details.Quantity]
Is it like this?
@Anonymous Yes it is correct. Here LineTotal is the name of calcuated column
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?