Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Power BI desktop add a new column calculated from two tables

Posted on by 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])

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans