MBA 620 5-1 Power BI: Visualization of
Financial Performance | 2026 Update with
complete solutions.
Practice Question Bank & Answer Rationale
THIS PACK CONTAINS
99 exam-style multiple-choice questions. Each question includes the correct answer and a complete rationale
for focused revision.
COVERAGE
This exam evaluates mastery of Power BI for visualizing financial performance, covering data modeling, DAX
measures, financial statement visualization, time intelligence, and dashboard design. It emphasizes practical
application of business intelligence tools to real-world financial analysis scenarios.
STUDY GUIDE
Recommended duration: 3 hours. Passing target: 80%.
HIGHP - Page 1 of 35
,1. In Power BI, which DAX function is most appropriate for calculating the year-to-date
(YTD) revenue when the fiscal year starts in July?
[ ] A. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "06/30")
[ ] B. DATESYTD('Date'[Date], "06/30")
[ ] C. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "07/01")
[ ] D. CALCULATE(SUM(Sales[Revenue]), DATESYTD('Date'[Date], "07/01"))
CORRECT: A. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "06/30")
TOTALYTD with the optional year-end date argument "06/30" correctly calculates YTD for a fiscal year ending
June 30. Option B returns a table, not a scalar. Option C uses July 1 as year-end, which is incorrect. Option
D is syntactically valid but DATESYTD with "07/01" would define year-end as July 1, not June 30.
2. When building a financial dashboard, which Power BI visual is best suited for
displaying the composition of expenses by category as a percentage of total expenses?
[ ] A. Stacked bar chart
[ ] B. 100% stacked column chart
[ ] C. Pie chart
[ ] D. Treemap
CORRECT: D. Treemap
A treemap is ideal for showing hierarchical composition and relative proportions using nested rectangles,
making it effective for expense categories. While pie charts show proportions, they are less effective with
many categories. 100% stacked column charts compare across categories but not as clearly for
part-to-whole. Stacked bar charts show absolute values, not percentages.
3. Which Power Query transformation should be applied to ensure that a column
containing financial amounts in different currencies is standardized to USD for reporting?
[ ] A. Add a custom column with a fixed exchange rate.
[ ] B. Use the 'Currency' data type and format.
[ ] C. Merge with an exchange rate table and multiply.
[ ] D. Apply a conditional column to convert based on currency code.
CORRECT: C. Merge with an exchange rate table and multiply.
Merging with an exchange rate table and multiplying is the correct approach to convert multiple currencies to
USD dynamically. Option A uses a fixed rate, which is inaccurate. Option B only changes formatting, not
values. Option D is possible but less maintainable than a merge with a rates table.
4. In a Power BI data model, what is the primary purpose of creating a relationship
between a fact table and a dimension table?
[ ] A. To enable filtering and aggregation across tables.
HIGHP - Page 2 of 35
, [ ] B. To reduce the size of the data model.
[ ] C. To improve visual rendering speed.
[ ] D. To allow cross-table calculations without DAX.
CORRECT: A. To enable filtering and aggregation across tables.
Relationships enable filtering and aggregation across tables, which is fundamental for slicing data in visuals.
They do not inherently reduce model size or improve rendering speed. Cross-table calculations still require
DAX; relationships just provide the context.
5. Which DAX function is used to calculate the previous year's sales for a comparative
income statement?
[ ] A. SAMEPERIODLASTYEAR
[ ] B. DATEADD
[ ] C. PARALLELPERIOD
[ ] D. PREVIOUSYEAR
CORRECT: A. SAMEPERIODLASTYEAR
SAMEPERIODLASTYEAR returns a table of dates shifted one year back, ideal for year-over-year
comparisons. DATEADD is more flexible but requires specifying the interval. PARALLELPERIOD shifts by a
specified number of intervals. PREVIOUSYEAR returns the entire previous year, not the same period.
6. When creating a measure for gross profit margin, which DAX expression correctly
calculates it as a percentage?
[ ] A. DIVIDE(SUM(Sales[GrossProfit]), SUM(Sales[Revenue]))
[ ] B. SUM(Sales[GrossProfit]) / SUM(Sales[Revenue])
[ ] C. DIVIDE(SUM(Sales[Revenue]) - SUM(Sales[COGS]), SUM(Sales[Revenue]))
[ ] D. SUM(Sales[Revenue]) - SUM(Sales[COGS]) / SUM(Sales[Revenue])
CORRECT: C. DIVIDE(SUM(Sales[Revenue]) - SUM(Sales[COGS]), SUM(Sales[Revenue]))
Gross profit margin is (Revenue - COGS) / Revenue. Option C correctly uses DIVIDE for safe division.
Option A uses GrossProfit column, which may not exist. Option B lacks safe division. Option D has incorrect
operator precedence.
7. Which Power BI feature allows users to drill down from a yearly summary to quarterly
and monthly financial data?
[ ] A. Drill-through
[ ] B. Hierarchy
[ ] C. Bookmarks
[ ] D. Tooltips
HIGHP - Page 3 of 35
, CORRECT: B. Hierarchy
A hierarchy in a visual (e.g., Year > Quarter > Month) enables drill-down. Drill-through navigates to a different
page. Bookmarks save states. Tooltips show details on hover but not drill-down.
8. In Power BI, what is the recommended approach to handle missing values in a financial
dataset to avoid skewed averages?
[ ] A. Replace with zero.
[ ] B. Remove rows with missing values.
[ ] C. Impute with the mean of the column.
[ ] D. Leave as null and use AVERAGE function.
CORRECT: B. Remove rows with missing values.
Removing rows with missing values is often recommended to avoid skewing averages, especially if missing
at random. Replacing with zero can distort averages. Imputing with mean is an option but may not be
appropriate for financial data. AVERAGE ignores nulls but may still be skewed if missingness is systematic.
9. Which visual is most effective for displaying the trend of net income over the past 12
months?
[ ] A. Line chart
[ ] B. Clustered column chart
[ ] C. Scatter chart
[ ] D. Waterfall chart
CORRECT: A. Line chart
A line chart is best for showing trends over time. Clustered column charts compare categories but are less
clear for trends. Scatter charts show relationships. Waterfall charts show cumulative effects, not trends.
10. When using Power BI to analyze financial performance, what does the Q&A feature
allow users to do?
[ ] A. Ask natural language questions and get visual answers.
[ ] B. Query the database directly with SQL.
[ ] C. Create complex DAX measures automatically.
[ ] D. Schedule data refreshes.
CORRECT: A. Ask natural language questions and get visual answers.
Q&A lets users ask natural language questions and receive visual responses. It does not directly query SQL,
create DAX, or schedule refreshes.
HIGHP - Page 4 of 35
Financial Performance | 2026 Update with
complete solutions.
Practice Question Bank & Answer Rationale
THIS PACK CONTAINS
99 exam-style multiple-choice questions. Each question includes the correct answer and a complete rationale
for focused revision.
COVERAGE
This exam evaluates mastery of Power BI for visualizing financial performance, covering data modeling, DAX
measures, financial statement visualization, time intelligence, and dashboard design. It emphasizes practical
application of business intelligence tools to real-world financial analysis scenarios.
STUDY GUIDE
Recommended duration: 3 hours. Passing target: 80%.
HIGHP - Page 1 of 35
,1. In Power BI, which DAX function is most appropriate for calculating the year-to-date
(YTD) revenue when the fiscal year starts in July?
[ ] A. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "06/30")
[ ] B. DATESYTD('Date'[Date], "06/30")
[ ] C. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "07/01")
[ ] D. CALCULATE(SUM(Sales[Revenue]), DATESYTD('Date'[Date], "07/01"))
CORRECT: A. TOTALYTD(SUM(Sales[Revenue]), 'Date'[Date], "06/30")
TOTALYTD with the optional year-end date argument "06/30" correctly calculates YTD for a fiscal year ending
June 30. Option B returns a table, not a scalar. Option C uses July 1 as year-end, which is incorrect. Option
D is syntactically valid but DATESYTD with "07/01" would define year-end as July 1, not June 30.
2. When building a financial dashboard, which Power BI visual is best suited for
displaying the composition of expenses by category as a percentage of total expenses?
[ ] A. Stacked bar chart
[ ] B. 100% stacked column chart
[ ] C. Pie chart
[ ] D. Treemap
CORRECT: D. Treemap
A treemap is ideal for showing hierarchical composition and relative proportions using nested rectangles,
making it effective for expense categories. While pie charts show proportions, they are less effective with
many categories. 100% stacked column charts compare across categories but not as clearly for
part-to-whole. Stacked bar charts show absolute values, not percentages.
3. Which Power Query transformation should be applied to ensure that a column
containing financial amounts in different currencies is standardized to USD for reporting?
[ ] A. Add a custom column with a fixed exchange rate.
[ ] B. Use the 'Currency' data type and format.
[ ] C. Merge with an exchange rate table and multiply.
[ ] D. Apply a conditional column to convert based on currency code.
CORRECT: C. Merge with an exchange rate table and multiply.
Merging with an exchange rate table and multiplying is the correct approach to convert multiple currencies to
USD dynamically. Option A uses a fixed rate, which is inaccurate. Option B only changes formatting, not
values. Option D is possible but less maintainable than a merge with a rates table.
4. In a Power BI data model, what is the primary purpose of creating a relationship
between a fact table and a dimension table?
[ ] A. To enable filtering and aggregation across tables.
HIGHP - Page 2 of 35
, [ ] B. To reduce the size of the data model.
[ ] C. To improve visual rendering speed.
[ ] D. To allow cross-table calculations without DAX.
CORRECT: A. To enable filtering and aggregation across tables.
Relationships enable filtering and aggregation across tables, which is fundamental for slicing data in visuals.
They do not inherently reduce model size or improve rendering speed. Cross-table calculations still require
DAX; relationships just provide the context.
5. Which DAX function is used to calculate the previous year's sales for a comparative
income statement?
[ ] A. SAMEPERIODLASTYEAR
[ ] B. DATEADD
[ ] C. PARALLELPERIOD
[ ] D. PREVIOUSYEAR
CORRECT: A. SAMEPERIODLASTYEAR
SAMEPERIODLASTYEAR returns a table of dates shifted one year back, ideal for year-over-year
comparisons. DATEADD is more flexible but requires specifying the interval. PARALLELPERIOD shifts by a
specified number of intervals. PREVIOUSYEAR returns the entire previous year, not the same period.
6. When creating a measure for gross profit margin, which DAX expression correctly
calculates it as a percentage?
[ ] A. DIVIDE(SUM(Sales[GrossProfit]), SUM(Sales[Revenue]))
[ ] B. SUM(Sales[GrossProfit]) / SUM(Sales[Revenue])
[ ] C. DIVIDE(SUM(Sales[Revenue]) - SUM(Sales[COGS]), SUM(Sales[Revenue]))
[ ] D. SUM(Sales[Revenue]) - SUM(Sales[COGS]) / SUM(Sales[Revenue])
CORRECT: C. DIVIDE(SUM(Sales[Revenue]) - SUM(Sales[COGS]), SUM(Sales[Revenue]))
Gross profit margin is (Revenue - COGS) / Revenue. Option C correctly uses DIVIDE for safe division.
Option A uses GrossProfit column, which may not exist. Option B lacks safe division. Option D has incorrect
operator precedence.
7. Which Power BI feature allows users to drill down from a yearly summary to quarterly
and monthly financial data?
[ ] A. Drill-through
[ ] B. Hierarchy
[ ] C. Bookmarks
[ ] D. Tooltips
HIGHP - Page 3 of 35
, CORRECT: B. Hierarchy
A hierarchy in a visual (e.g., Year > Quarter > Month) enables drill-down. Drill-through navigates to a different
page. Bookmarks save states. Tooltips show details on hover but not drill-down.
8. In Power BI, what is the recommended approach to handle missing values in a financial
dataset to avoid skewed averages?
[ ] A. Replace with zero.
[ ] B. Remove rows with missing values.
[ ] C. Impute with the mean of the column.
[ ] D. Leave as null and use AVERAGE function.
CORRECT: B. Remove rows with missing values.
Removing rows with missing values is often recommended to avoid skewing averages, especially if missing
at random. Replacing with zero can distort averages. Imputing with mean is an option but may not be
appropriate for financial data. AVERAGE ignores nulls but may still be skewed if missingness is systematic.
9. Which visual is most effective for displaying the trend of net income over the past 12
months?
[ ] A. Line chart
[ ] B. Clustered column chart
[ ] C. Scatter chart
[ ] D. Waterfall chart
CORRECT: A. Line chart
A line chart is best for showing trends over time. Clustered column charts compare categories but are less
clear for trends. Scatter charts show relationships. Waterfall charts show cumulative effects, not trends.
10. When using Power BI to analyze financial performance, what does the Q&A feature
allow users to do?
[ ] A. Ask natural language questions and get visual answers.
[ ] B. Query the database directly with SQL.
[ ] C. Create complex DAX measures automatically.
[ ] D. Schedule data refreshes.
CORRECT: A. Ask natural language questions and get visual answers.
Q&A lets users ask natural language questions and receive visual responses. It does not directly query SQL,
create DAX, or schedule refreshes.
HIGHP - Page 4 of 35
