Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Vinu Hari]

Hi, Need the support to derive the foreign currency value against base currency (AED)

Attached 2 tables

Sheet 1 (Data sheet) where the base currency is reported in AED and i want to get the value to be converted in to foreign currency based on exchange rate of different month (ref Exchange Rate sheet)

Sheet 2 (Exchange Rate) exchange rate on a monthly basis.

Please help

Thanks
Srikanth

——————————
Srikanth Hari
FA
——————————

[Vincent Lacomme]

Hi Srikanth,

Enclosed is a simple example of using the Exchange Rate table to get to the data sheet result.

Hope that helps.

——————————
Vincent L.
Chartered accountant – Expert-comptable
——————————
——————————————-