Learn how to create a custom calculated field in Power BI to convert order totals from local currencies to USD and display totals by region, meeting the specific business requirement.
Table of Contents
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has locations in multiple countries and regions across four continents.
The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table.
You need to create a visualization that displays the total amount of orders by country/region in USD.
Proposed solution: Create a custom calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?
A. Yes
B. No
Answer
A. Yes
Explanation
The proposed solution meets the goal. Creating a custom calculated field of type currency on the order table that converts the order total to USD using the exchange rate table is the correct approach to visualize the total amount of orders by country/region in USD in a Power BI chart.
This calculated field will leverage the exchange rate table and apply the appropriate conversion rate based on the local currency of the order. Once the calculated field is created, it can be added to the Power BI visualization, grouped by country/region, to display the desired view of total order amounts in USD across different regions.
Microsoft Power Platform App Maker PL-100 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform App Maker PL-100 exam and earn Microsoft Power Platform App Maker PL-100 certification.