The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?