Forum Discussion

hadjigeo's avatar
hadjigeo
Helper I
6 years ago
Solved

Exchange rate

Hi,   i have a column with values that has multiple currencies such as:   AED USD EUR SAR and i want to create a new column that will convert all of them in USD and one more that will convert...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

     hi hadjigeo 

    If so, just adjust the formula to create a measure instead of column

    lastest rate = MAXX(TOPN(1,FILTER('Dim daily rates','Dim daily rates'[bpc_name]=MAX('Table'[bpc_name])),'Dim daily rates'[bpc_ExchangeDate],DESC),[bpc_ExchangeRate])

     

    Regards,

    Lin

hadjigeo's avatar
hadjigeo
Helper I
6 years ago

Hi v-lili6-msft  for the step 2 when i create a table it doesnt let me to use the MAXX.

 

i Am using a directquery, does this has to do anything with that?

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

 hi hadjigeo 

If so, just adjust the formula to create a measure instead of column

lastest rate = MAXX(TOPN(1,FILTER('Dim daily rates','Dim daily rates'[bpc_name]=MAX('Table'[bpc_name])),'Dim daily rates'[bpc_ExchangeDate],DESC),[bpc_ExchangeRate])

 

Regards,

Lin

  • ZChase's avatar
    ZChase
    New Member
    5 years ago

    whatif exchange rates table is missing dates. Should i fix the exchange rate table to fill up the missing dates or use measure to calculate the value in USD currency with reference to native currency and transaction dates.