Calculate Translated Balance using movement data in base currency
I would like to calculate the closing balance and opening balance in ZAR currency from the base currencies using a DAX measure. My current attempt wont work. Perhaps it is a syntax issue in where I multiply with the currency rate.
I have a row for each month and columns for the base movement amount, the closing rate and opening currency rate for the month.
My current attempt to calculate the closing balance at each selected date: