web

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

News and Announcements icon

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
Copy link

Link copied!

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

#2

Pallavi Phade 102 Super User 2026 Season 1

#3

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

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