Tag: Power BI Exchange Rates

Power BI Exchange Rates: An Update To Multiple Currencies Management

By Sam McKay, CFA on October 23, 2019October 25, 2019

***** Related Course Modules*****Advanced Analytics in Power BI Business Analytics Series Mastering DAX Calculations ***** Related Support Forum Posts *****Multi-currencies with correct currency label Converting currency Time intelligence function inside LOOKUP (need to create the ROW by currency context inside DAX) For more exchange rates support queries to review see here….

Posted in: Advanced DAX Currencies, Advanced DAX Exchange Rates, LASTNONBLANK Power BI, Managing Currencies Power BI, Managing Exchange Rates, Multiple Currencies Power BI, Power BI Exchange Rates

Business Intelligence Data Modeling DAX Financial Reporting Power BI

Multiple Currency Logic In Power BI – LOOKUPVALUE Example

By Sam McKay, CFA on December 14, 2017July 24, 2019

Handling Multiple Currencies in Power BI w/DAX

A really common scenario within financial analysis is having to integrate currency rates across your transactional data. Most of the time, sales data is actually recorded regardless of the currency and the currency name or code is just placed inside a column. And it could be either USD, AUD, GBP, but it isn’t actually adjusted