nerdexam
Microsoft

PL-900 · Question #266

You are designing Power BI dashboards and reports to analyze the financial data for a company. You must analyze the past three years of data from the company's accounting system. You need to ensure…

The correct answer is A. Create aggregations. D. Create calculated columns. To ensure Power BI dashboards display only required financial data from the past three years, you can either summarize the data using aggregations or create calculated columns to derive and filter specific values.

Submitted by emma.c· Apr 18, 2026Describe the business value of Microsoft Power Platform

Question

You are designing Power BI dashboards and reports to analyze the financial data for a company. You must analyze the past three years of data from the company's accounting system. You need to ensure that dashboards only display required data. What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

  • ACreate aggregations.
  • BImport data into Microsoft Dataverse.
  • CShare dashboards.
  • DCreate calculated columns.

How the community answered

(27 responses)
  • A
    85% (23)
  • B
    11% (3)
  • C
    4% (1)

Why each option

To ensure Power BI dashboards display only required financial data from the past three years, you can either summarize the data using aggregations or create calculated columns to derive and filter specific values.

ACreate aggregations.Correct

Aggregations in Power BI allow you to pre-summarize large datasets, which can filter the data presented to a required scope, such as the past three years, and improve performance.

BImport data into Microsoft Dataverse.

Importing data into Microsoft Dataverse is a method for data storage and integration, not a mechanism within Power BI to filter or display specific data on dashboards.

CShare dashboards.

Sharing dashboards controls who can view the dashboard, not which specific data within the dashboard is displayed or filtered for analysis.

DCreate calculated columns.Correct

Calculated columns enable you to add new columns based on existing data, allowing you to create specific criteria (e.g., year filters) that ensure only the past three years of data are displayed.

Concept tested: Power BI data modeling and filtering

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations-about

Topics

#Power BI#Data Modeling#Aggregations#Calculated Columns

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-900 Practice