Forum Discussion
Adding two measurements from different tables
Hi laurahoff97 ,
As per your description, I have created two tables and created relationships for them.
Create measure.
AgreementTotal = SUM(Agreements[HardwareCost]) + SUM(Agreements[SoftwareCost]) + SUM(Agreements[LaborCost]) + SUM(Agreements[TravelCost])RecordTotal = SUM(Records[HardwareCost]) + SUM(Records[SoftwareCost]) + SUM(Records[LaborCost]) + SUM(Records[TravelCost])RemainingAmount = Agreements[AgreementTotal] - 'Agreements'[RecordTotal]If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi laurahoff97 ,
As per your description, I have created two tables and created relationships for them.
Create measure.
AgreementTotal = SUM(Agreements[HardwareCost]) + SUM(Agreements[SoftwareCost]) + SUM(Agreements[LaborCost]) + SUM(Agreements[TravelCost])
RecordTotal = SUM(Records[HardwareCost]) + SUM(Records[SoftwareCost]) + SUM(Records[LaborCost]) + SUM(Records[TravelCost])
RemainingAmount =
Agreements[AgreementTotal] - 'Agreements'[RecordTotal]
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! I was unaware I could create a measure in one data table that references columns from another.