Microsoft
PL-100 · Question #67
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…
The correct answer is B. No. Instead use a calculated field. Need to calculate the exchange rate in USD. Calculated columns are calculated in real-time when they are retrieved. https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes
Analyze and visualize data
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 rollup field of type currency on the country/region table that aggregates all the total amounts for the orders from that country/region and display this rollup field in a Power BI chart. Does the solution meet the goal?
Options
- AYes
- BNo
How the community answered
(34 responses)- A24% (8)
- B76% (26)
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. https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes
Topics
#Currency Conversion#Rollup Fields#Data Aggregation#Power BI Data Visualization
Community Discussion
No community discussion yet for this question.