Need to calculate a monthly average

(0) Share

Report

Posted on by Hilda Steyn

297

I have a table with daily exchange rate data called Daily Exchange Rates.

I have another table, Investment Balance, in which I have to use the data from a column called Foreign Balance, to calculate another column called Local Balance, using the AVERAGE exchange rate of the month in the formula.

How on earth do I do this?

I know the Local Balance column must be of type formula, but I don't know how to write the formula to use the Balance Date and use that to extract an average from the other table, and then do the calculation.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @hildasteyn, do you have a relationship between the two tables?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Hilda Steyn 297 on at

Like (0)

Report
Copy link

Link copied!

No. There isn't a relationship. The Daily Exchange Rate table are simply there for calculation purposes. It doesn't relate to any other table.

Was this reply helpful? Yes No