Forum Discussion
need help for foreign currency selection and converting values based on that
Yes, rates are available for all days.
- Each currency has conversion rates for all other currencies for each date.
- END_DATE field changed to date format
Please also note that the structure of the FCRATE Table is as follows,
Let's assume transaction amounts are in the XOF rate.
So, if I select GBP on the slicer and the date 30/03/2020 from the date filter, What I'm expecting is the transaction amount will be changed from XOF to reflect the GBP amount for that date.
For example,
1. if the transaction amount is 10,000 in XOF, once the slicer is set to GBP & date filter is applied as 30/03/2020, the transaction amount should be changed to 13.5689
2. Let's assume transaction amounts are in the CAD rate.
if the transaction amount is 10,000 in CAD, once the slicer is set to USD & date filter is applied as 30/03/2020, the transaction amount should be changed to 7,058.5172,
likewise, the transaction amount needs to change based on the transaction currency, and the selected currency on slicer & date.
- tamerj1
Community Champion
Anonymous
My previous reply solution was based on the assumption that the Date table filters both 'Project cost' and FCRATE tables. If this is the case then I don't see why it shouldn't work.In case a range of dates is selected, the following should work
Project Cost Amount = SUMX ( VALUES ( 'Date'[Date] ), CALCULATE ( SUM ( 'Project Cost'[Transaction Amount] ) * SELECTEDVALUE ( FCRATE[USD], 1 ) ) )
