Forum Discussion
gomezc73
Helper V
Helper VCalendar and Weekly exchange rate
Hello, I need help with this issue. I have a weekly exchange rate report, it is downloaded every saturday.. Then in the report if I need a exchange rate of Monday or Tuesday by example is ne...
@gomezc73 , locate the attachment with the solution.
Greg_Deckler
Community Champion
Community Championgomezc73 - You are basically looking at Lookup Min/Max kind of - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
In your case,
Measure =
VAR __Date = MAX('Table'[Date])
VAR __RateDate = MAXX(FILTER('ExchangeRates',[Date]<=__Date && [Exchange Rate] <> ""),[Date])
RETURN
MAXX(FILTER('ExchangeRates',[Date] = __RateDate),[Exchange Rate])