In this tutorial, you’ll learn how to handle missing data in a currency rates table using DAX and power query. You’ll learn the different ways to manage the missing rates in your table and present them effectively in a dashboard in Power BI. You may watch the full video of this tutorial at the bottom
Tag: Multiple Currencies Power BI
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
***** 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….