From the course: Power BI for Finance
Join today to access over 24,900 courses taught by industry experts.
Converting currencies - Power BI Tutorial
From the course: Power BI for Finance
Converting currencies
- [Instructor] Let's say that we want to convert our financials from one currency to another. To do so, we can use DAX measures to convert the value. We can also use DAX measure string formatting to display the units of the currency correctly. We'll use the SELECTEDVALUE DAX measure to extract a single value to use in our currency conversion. In Power BI Desktop, we have a table called Convert Currencies. It consists of the currency name, its conversion rate, and its format. Let's use the data in this table to both convert the currency amount from US dollars to other currencies based on the slicer selection, and also change its format as well. Let's start by adding the currency name to the values in a slicer visual. We'll leave it as a single select option because we only want to select one currency to use at a time. Let's first calculate our converted currency. We'll create a new measure, and I'll call this Converted Amount, and I'm going to set it equal to the SELECTEDVALUE of our…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.