Currency Converted column in a table based on FX rate date and FX rate

[ybhatnagar]

Hi

I dont want to create a measure. I have a column with a currency say EUR and Order date(YYYY/MM/DD) in Orders table. I am maintaining a seperate FX table in power bi where I have USD rates defined for each day of the month in YYYY/MM/DD. I want to create a new column in Order wherein for each row in Order table gets converted to USD based on FX rate defined for the Date match (Ord date with FX rate date). 

I have created the measure and it works but I want to have a column in the table.

Thanks

[v-juanli-msft]

Hi @ybhatnagar

Could you share some data example?

Best Regards

Maggie