Tag: Currency Conversion

Solving Missing Currency Rates With Power Query In Power BI

In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how to work things out when the currency rates table doesn’t have a currency rate on

Continue reading

Power BI Challenge #9 Wrap Up

We’re once again done with another Power BI Challenge. Judging who the winner is has become more and more challenging as we see participants getting better and better with every round. This challenge is about currency conversion. It involves a company that buys scrap and waste recyclables. Because the company deals with clients from all

Continue reading

Power BI Challenges Now On Its 9th Leg

We’ve started the 9th leg of our Power BI Challenges, this time focusing on currency conversion. There’s so much conversation within the Enterprise DNA Forum on this topic that we decided it’s about time we dedicate a challenge to it. As you probably know, we aim to keep things interesting by highlighting different industries every

Continue reading

Format Currencies In Power BI Using DAX

This tutorial will focus on currency conversions and how to format these converted currencies using DAX in Power BI. In this example, Sales will be used to run a report based on different currencies from World Wide Importer’s data. Assumptions Used These are the assumptions that you should remember in this remodelling: Creating The Currency

Continue reading

Creating A Currency Conversion Table In Power BI

In this tutorial, we’re going to learn how to create a currency conversion table for Sales in Power BI using DAX measures. Using this technique, we would only need to create a simple slicer to convert a currency to another. This is especially useful when dealing with data containing multiple currencies in Power BI. For

Continue reading