Currency Conversion Normalization - Time Dependent

Hi Anonymous 

I made a sample to have a test.

Data Table:

Rate Table:

Calendar Table:

Calendar = ADDCOLUMNS(CALENDAR(DATE(2020,01,01),DATE(2021,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]))

Measures:

GBP = 
VAR _RATE =
    CALCULATE (
        SUM ( 'Rate'[Rate USD-GBP] ),
        FILTER (
            'Rate',
            AND (
                'Rate'[Year] = MAX ( 'Table'[Year] ),
                'Rate'[Month] = MAX ( 'Table'[Month] )
            )
        )
    )
VAR _GBP =
    _RATE * SUM ( 'Table'[USD] )
RETURN
    _GBP

USD in Current Rate = 
VAR _SELECTYEAR =
    SELECTEDVALUE ( 'Calendar'[Year] )
VAR _SELECTMONTH =
    SELECTEDVALUE ( 'Calendar'[Month] )
VAR _RATE =
    CALCULATE (
        SUM ( 'Rate'[Rate USD-GBP] ),
        FILTER (
            ALL ( 'Rate' ),
            'Rate'[Year] = _SELECTYEAR
                && 'Rate'[Month] = _SELECTMONTH
        )
    )
RETURN
    ROUND ( DIVIDE ( 1, _RATE ), 2 ) * [GBP]

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.