web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Power BI desktop add a...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Power BI desktop add a new column calculated from two tables

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member 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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

André Arnaud de Cal... 76 Super User 2025 Season 2

#2

Martin Dráb 55 Most Valuable Professional

#3

Anthony Blake 43 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans