Tag: Multiple Currencies Power BI

Currency Rates In Power BI: Handling Missing Data

Hierarchies In Power BI Visualizations

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 can watch the full video of this tutorial at the bottom of

Continue reading

Multiple Currency Logic In Power BI – A LOOKUPVALUE Example

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

Continue reading

Power BI Exchange Rates: An Update To Multiple Currencies Management

There are many instances with financial analysis wherein we need to integrate exchange rates, and we can do this easily in Power BI. You may watch the full video of this tutorial at the bottom of this blog. I have actually shown an example of how to do this using the LOOKUPVALUE function in Power

Continue reading