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
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
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
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
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
