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.
amitchandak
Super User
Super User@gomezc73 , locate the attachment with the solution.
gomezc73Helper V
Helper VHello, I tried using
New exchange Rate = maxx(filter('Table', [Date]<=EARLIERER('Table'[Date])),LASTNONBLANKVALUE('Table'[Date IN JDE],max('Table'[ Exchange Rate ]))))
And it works only with a "Currency From", By Example if the tables is only From EUR to USD.
But when i added other Currencys in the tables the formula doesn't work. It bring the MAX Exchange rates From other Currencys..
How The formula can be improve to consider the "Currency From"?