Forum Discussion
LASTNONBLANK issue
I have a listing of sales invoices which I need to translate the value to USD using the rate on the date of the invoice. I have set up an FX table that automatically imports the FX rates from the E...
some_bih
Community Champion
Community ChampionHi Drikus
Think about part - I guess typo? Put longer year as we are approaching to this deadline in less than 100 days:)
CALENDAR(DATE(2021,01,01),Date(2023,12,01)),
Great articles for your case, worth reading and implementations
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
or
https://www.daxpatterns.com/currency-conversion/
Hope this help, kudos appreciated.