Forum Discussion
Helper IFinancial portfolio Daily calculation with FX
OK, I've done it (use the same link as above). There are 2 major approaches to this. One solution is to disconnect the Dates table from the other ones. The other is to disconnect the tables inside the relevant measures. I did check both options---they do work---but then opted for the latter one. It'll be harder to understand but I thought you'd like to maintain the relationships for other purposes.
Daxer, perfect this is working.. Thanks
Solution Sage
Please refer to this article at www.sqlbi.com to know how to do such things correctly. Please do not try to reinvent the wheel. You don't want to waste your time.
Helper IHi Daxer, Thanks for sharing, I can see that this is related to a single sales currency transaction. The difference here is that even when the sale (cash flow) event happened at a certain date, I need to reconvert the balance very day as the FX change. Here the figure I need to convert is the balance of the sum (cummulated measure of cash flows until the required date) Appreicate if you can share with me how I coud do this
- daxer-almighty
Does what Jihwan_Kim did not cut it?
- AlejandroVazque
Unfortunately no, as ou can see, in the answer he gently provided me , for example for 3rd of February 1/02/2020 I have lost the USD balance amount I had the previous day and the USD is not updated to the new USD rate of that date (should appear 9.67 USD)
- daxer-almighty
Looking at the tables you posted above... The FX table does not have all the dates that can be found in the Cash Flow table. Are you absolutely sure you'll have exchange rates for all the dates in your model?