Forum Discussion

carlomoretto's avatar
carlomoretto
Frequent Visitor
6 years ago

Dynamic currency conversion

Hello,   I'm struggling with an apparently simple task: dynamically converting fact table amounts to desired currency at the latest FX rate available, choosing the latest FX rate dynamically based ...
Need Help
carlomoretto's avatar
carlomoretto
Frequent Visitor
6 years ago

Hello amitchandak! Thanks for your reply!

I had checked both links:

  1. Suggests a calculated column solution: however, I don't think a calculated column will work in my case, due to its nature
  2. Has all amounts already in one currency and just converts them to another currency, which is a simpler case than mine

 

Any other solution that fits my case?

  • carlomoretto's avatar
    carlomoretto
    Frequent Visitor
    6 years ago

    Hello,

     

    Thanks for your input!

    I know that video actually. That is a static conversion though, ain't it?

    I need the conversion to be dynamic based on the date selected by the user.