Microsoft PL-300 Exam Actual Questions

You have a Power Bl model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

Show Answer Hide Answer

You have a Power Bl model that contains two tables named Population and Date.

The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power Bl model contains two measures that have the following definitions.

Total Population = Sum ('Population'[Population Amount])

2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)

You create a table visual that displays Date[Year] and [2023 Population].

What will the table visual show?

Show Answer Hide Answer

You have a Power B1 report that contains the visuals shown in the following table.

You need to modify the location of each visual.

What should you modify for each visual?

Show Answer Hide Answer

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

Show Answer Hide Answer

You have a Power B1 report. The report contains a line chart that displays sales data for several regions.

You need to add an element to the report that will enable users to filter the sales data to include only a selected region.

Which two elements achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Show Answer Hide Answer