Forum Discussion
carlomoretto
6 years agoFrequent Visitor
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 ...
amitchandak
Super User
6 years agorefer 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
6 years agoFrequent Visitor
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!!