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
6 years agoSuper User
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
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!!