This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, I've got an end user trying to get the latest exchange rate for each currency to USD into a report in Power BI. I'm trying to duplicate the report in a SuiteAnalytics workbook but I can't find the currency exchange rate table. Where can I find this?

I need to come up with base currency, exchange rate, effective date, and last modified date.

In a Workbook you have the Currency Table

I found the Currency Exchange Rate Dataset, but cannot find a way to do MAX({lastmodifieddate})

Ok I'd forgotten to add the curly brackets before, but SuiteAnalytics still doesn't let me use the Oracle SQL "MAX" function.

We've solved for this in our netsuite power bi solution: <http://www.satorireporting.com|www.satorireporting.com>