I am trying to add a new column to sale order detail table, the new column = sale quantity (from sale order detail) * unit cost (from item table). here is my calculation. the error message said "could not find unit_cost". seems power BI did not recognize joined table Items. what is the syntax should be?
[Item_Ledger_Entry_Quantity]*(Items[unit_cost])
It is resolved. because I was trying to add a new column from transform, instead of the report page.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (