Hi,
I am working in Power Pivot. I have a table where I want to convert the values from Canadian dollars to USD using a separate forex rates table. Forex table has average rates by month. I want all the transactions in data table for a month to use similar month exchange rate and so on. So for April 2021 transactions, formula will search for April 2021 exchange rate and calculate the value on that basis. Can someone help me with the DAX formula please.
I am working in Power Pivot. I have a table where I want to convert the values from Canadian dollars to USD using a separate forex rates table. Forex table has average rates by month. I want all the transactions in data table for a month to use similar month exchange rate and so on. So for April 2021 transactions, formula will search for April 2021 exchange rate and calculate the value on that basis. Can someone help me with the DAX formula please.