Forum Discussion

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 ...

Super User

6 years ago

refer if these can help

https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi

https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

carlomoretto
Frequent Visitor
6 years ago
Hello amitchandak! Thanks for your reply!
I had checked both links:
Suggests a calculated column solution: however, I don't think a calculated column will work in my case, due to its nature
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?
- v-deddai1-msft
  Community Support
  6 years ago
  Hi carlomoretto ,
  
  Would you please refer to https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2?
  
  Best Regards,
  Dedmon Dai
  - 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.
carlomoretto
Frequent Visitor
6 years ago
Hello amitchandak !

Thank you for your input!
Unfortunately, both examples refer to cases that are much simpler to handle.
You can check my pbix to see the difference.
Do you know of any approach that would suit my case?

Thanks!!

Related content