Exchange rate conversion with date range

Hey FaizanRao ,

as calculated column something like this should do it:

Sales in USD =
VAR vInvoiceDateCurrentRow = 'Table 1'[Invoice Date]
VAR vCurrencyCurrentRow = 'Table 1'[Sales Currency]
VAR vExchangeRate =
    CALCULATE(
        MAX( 'Table 2'[Exchange Rate] ),
        'Table 2'[Currency From] = vCurrencyCurrentRow
            && 'Table 2'[Currency To] = "USD"
            && 'Table 2'[Date From] <= vInvoiceDateCurrentRow
            && 'Table 2'[Date To] >= vInvoiceDateCurrentRow
    )
RETURN
    'Table 1'[Sales Value] * vExchangeRate