Tag: Power BI 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. You may watch the full video of this tutorial at the bottom of this blog. 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

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. You may watch the full video of this tutorial at the bottom of this blog. In this example, Sales will be used to run a report based on different currencies from World Wide Importer’s data. Assumptions

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. You may watch the full video of this tutorial at the bottom of this blog. Using this technique, we would only need to create a simple slicer to convert a currency to another.

Continue reading