Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Easy
Question 34
You want to create a calculated column in the Sales table to calculate the profit margin for each order. You decide to use the Modeling tab for this purpose.
Which option from the Modeling tab should you select to create the calculated column?
-
A
Manage Relationships
-
B
Quick Measure
-
C
New Measure
-
D
New Column
Reveal correct answer
Correct answer: D
Explanation
Requirements Breakdown:
Calculated Column: A column added to a table that computes a value for each row based on a DAX formula (e.g., profit margin = (Sales - Cost) / Sales).
Sales Table: The calculation applies to every row in this specific table.
Modeling Tab: The solution must be an option available in Power BI Desktop’s Modeling tab.
Solution:
To create a calculated column:Open Power BI Desktop and navigate to the "Modeling" tab.
In the "Calculations" group, select "New Column".
Enter a DAX formula in the formula bar, e.g., Profit Margin = (Sales[SalesAmount] - Sales[Cost]) / Sales[SalesAmount].
Press Enter to add the column to the Sales table, where it calculates a profit margin for each order.
The Microsoft documentation on calculated columns states, "Use the New Column option in the Modeling tab to add a calculated column with a DAX expression that computes a value for each row."
Why This Works:
Row-Level Calculation: A calculated column evaluates the DAX formula for every row in the Sales table, storing the result (e.g., profit margin per order), which matches the requirement.
Modeling Tab: "New Column" is specifically designed for this purpose, integrating seamlessly with the data model.
Persistence: The column becomes part of the table, usable in visuals or further calculations.
Why Not Other Options?:
New Measure: Found in the Modeling tab, this creates a measure (e.g., Total Profit Margin = SUM(Sales[SalesAmount] - Sales[Cost]) / SUM(Sales[SalesAmount])), which aggregates data across rows, not per order. The measures documentation notes, "Measures are for aggregations, not row-by-row values."
Quick Measure: Also in the Modeling tab, this generates predefined measure templates (e.g., running totals), not calculated columns. It’s for quick aggregations, not row-level logic, per the quick measures documentation.
Manage Relationships: This option configures table relationships, not calculations, as outlined in the relationships documentation.
A.
Manage Relationships is used for defining relationships between tables, not for creating calculations.
B.
Quick Measures provide prebuilt calculations based on common business logic.
You cannot manually define a formula with Quick Measures, making it unsuitable here.
C.
Measures are used for dynamic calculations based on filter context, not row-by-row computations.
A profit margin per order needs to be calculated at each row level, which measures cannot do.
D.
New Column allows users to create a calculated column in the Power BI data model.
A calculated column performs row-level calculations, meaning it evaluates each row individually rather than aggregating values dynamically.
Example of a Profit Margin calculated column:
- Profit Margin = (Sales[SalesAmount] - Sales[Cost]) / Sales[SalesAmount]
Since you want to calculate profit margin per order, you need a column, not a measure.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
