Does the solution meet the goal?

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 column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI Desktop and display this column in a Power BI chart by country/region.

Does the solution meet the goal?
A . Yes
B. No

View Answer

Answer: B

Explanation:

Instead use a calculated field.

Need to calculate the exchange rate in USD.

Calculated columns are calculated in real-time when they are retrieved.

Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes