Forum Discussion
Solved
Exchange Rates and Dates
Hi Power BI Community, I am working on a dataset for exchage rates. However, the exchange rates have specific dates associated to the exchange rate. I have the following exchange rate table: Cu...
Try to create a measure like below:
SALE_ = VAR _DATE = SELECTEDVALUE(Table2[Sale Date]) VAR _RATE = CALCULATE(MAX(Table1[Exchange Rate]),FILTER(Table1,Table1[Start Date]<=_DATE&&Table1[End Date]>=_DATE)) RETURN SUM(Table2[Sale Price])*_RATE
PowerEnthusiast , based on what I got so far new column in sales
rate = minx(filter(Rate, [Sale Date] >=[Start Date] && [Sale Date]<=[End date]),[Exchange Rate])
Hi amitchandak
The dates are in different tables - how do I look up from the Sales table to the Exchange Rate table?. Also, I don't think I will be able to reference a column for the dates in the query above. Seems to only want measures.
Try to create a measure like below:
SALE_ = VAR _DATE = SELECTEDVALUE(Table2[Sale Date]) VAR _RATE = CALCULATE(MAX(Table1[Exchange Rate]),FILTER(Table1,Table1[Start Date]<=_DATE&&Table1[End Date]>=_DATE)) RETURN SUM(Table2[Sale Price])*_RATE
