Forum Discussion
Anonymous
6 years agoNot applicable
Currency Conversion Calculation: use most recent conversion rate to replace rate in future
Hi everyone, I am creating a measure to convert currency. The logic of currency conversion is that if the opportunity has a future close date, then use the most recent exchange rate. But my m...
Greg_Deckler
6 years agoCommunity Champion
https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814
In your case, you are looking up the MAX of the data with appropriate filters.