Answered

Calculated column using data from two tables

(0) Share

Report

Posted on by EG-31080115-0

118

For Dataverse calculated column is it possible to use data from two tables? In Table1 I have a column that has Total# of units for each Lot#. In Table2 I have details for each unit and it includes Lot#. I want to add calculated column to Table1, "Units_Remaining", where calculation is something like:

Table1.Total# - Countif(Table2, And(Table2.Lot#=Table1.Lot#,IsBlank(Consumed)=true))

Is this possible?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, with new preview features.

With the Wave 2 release, calculated columns got an ENORMOUS increase in functionality by allowing you to code them in PowerFX as "Formula Columns". This really opens the flood gates for functionality in these col types, allowing you to use standard PowerFX syntax for doing things like pulling attributes off related records and creating complex calculations.

The list of supported functions is not complete, mind you, but there are already over 50 in there. See reference page here.

BUT... unfortunately because this capability is still so new the only editor experience for it is in Dataverse for Teams. The editor is rolling out region by region to full Dataverse right now, but might take another several weeks to complete, so you might have to wait a bit to get access to this one.

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report
Copy link

Link copied!

@cchannon --Thanks for the response. I had seen the Formula feature for Dataverse Teams and was hoping that some similar functionality already existed. I guess I'll have to be patient and wait for full implementation to take advantage. I'll leave thread open for now in case someone else has a work-around to offer up. If not I'll accept your response as solution. Thanks!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Microbes,

Adding supplement to @cchannon, we can achieve this using Microsoft Flow/ JavaScript or Plugins and Can Achieve the same behavior what you are expecting.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No