Formula to calculate a total year to date figure multiplied by the most current exchange rate

[abalserv]

hi Folks
Thanks for your help in solving one problem..now am trying to get a handle on another.

The aim of this formula is as follows:
summarise a column so that it adds up all the net_accounted but only those ones with an account status of BS (that's Balance sheet ....not anything else... ) (these are in two related tables) and multiply the total by the latest exchange rate for that currency (these rates are listed in a separate table and would include rates for dates later than the current one). So if I was calculating the BS balance for October, it would calculate the net_accounted for Balance sheet only using the Balance sheet Exchange rate for that currency for October. In November it would use the November exchange rate etc. I do have a calendar table as well.
I've got this formula - which is "correct" according to "check formula" but alas, doesn't give me what I'm looking for...i'm missing something in the exchange rate bit....

calculate([Sum of sla_net_accounted],Accounts_Codes[Status]="BS",'FX Combination'[Exchange Rate])

 

[abalserv]

Figured out this bit myself..created two new measures - one for PL stuff only and the other for BS stuff only