Exchange rates for ENDOFMONTH

Question

I have an Exchange Rate table that I'm trying to get the ending months calculation

It's using a minimum of 3 currencies lets use GBP USD EUR

I need to return when selecting that currency the End of month Currency

So something like k

EOMCcy=:IF(HASONEVALUE('Ccy'[Currency Symbol]), 
CALCULATE([Exchange Rate],ENDOFMONTH('Exchange Rates'[Date]) ,BLANK()))

I know I need to validate the currency somewhere and I'm trying many thinks as I have a fromCcy and toCccy column e.g GBP USD This would show in the [Exchange Rate] column =1.22

I was hoping someone can point me in the right direction or offer a better method with my code

Thank all

Could you edit to include sample data and expected result in your question? It is hard to understand your problem with that short description. — alejandro zuleta

user2181700 user2181700 · Accepted Answer · 2017-01-26T23:48:25

So I think I solved it

    EOMCcy:=IF(HASONEVALUE('Ccy'[Currency Symbol]),

CALCULATE (
    SUM ([ExchangeRate]),
    FILTER (
         ALL ( 'Exchange Rates'[Date]),
         'Exchange Rates'[Date] = ENDOFMONTH('Exchange Rates'[Date])
     )
 ),BLANK())

Exchange rates for ENDOFMONTH

1 Answers