Power BI desktop add a new column calculated from two tables

(0) Share

Report

Posted on by Community Member Microsoft Employee

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])

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Power BI desktop add a new column calculated from two tables

It is resolved. because I was trying to add a new column from transform, instead of the report page.