MB-910 Describe Dynamics 365 Customer Insights Practice Question
You are a Dynamics 365 consultant for a manufacturing company that uses Customer Insights to unify data from their CRM (Dynamics 365 Sales) and their ERP (Dynamics 365 Finance). They want to use Customer Insights to calculate a measure for 'Average Order Value' per customer. After creating the measure, they notice that the values are incorrect because the currency from the ERP is in euros, while the CRM uses US dollars. The ERP data includes a currency conversion rate field. What should you do to ensure the measure uses a consistent currency?
⚠ Common exam trap
Many candidates confuse the 'CurrencyConvert' function available in Power Query (M) with a similar function in Customer Insights measures, or assume that a separate measure can be nested inside another measure, neither of which is supported in the measure definition interface.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a calculated column in the unified data that multiplies the order value by the conversion rate.
In Dynamics 365 Customer Insights, calculated columns are the appropriate way to transform data at the entity level before using it in measures. By creating a calculated column that multiplies the order value by the conversion rate, you ensure all values are in a consistent currency (USD) before the 'Average Order Value' measure aggregates them. This approach directly addresses the mismatch between EUR in the ERP and USD in the CRM without altering source systems or using unsupported functions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Change the ERP data source to output values in USD.
Why it's wrong here
You cannot change source data.
- ✗
Create a measure for conversion rate and use it in the average order value measure.
Why it's wrong here
Measures cannot reference other measures.
- ✗
Use the 'CurrencyConvert' function in the measure to convert values.
Why it's wrong here
No such function exists in Customer Insights.
- ✓
Create a calculated column in the unified data that multiplies the order value by the conversion rate.
Why this is correct
Calculated columns can transform data.
Go deeper
Related to this question
About these practice questions
One of 941 original MB-910 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This MB-910 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the MB-910 exam.