PL-300 Exam Dumps : Microsoft Power BI Data Analyst

Box 1: Top N

Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

Once you drag to SKU to Visual level filter you should get Top N option

Note: The two most common filter types: automatic and manual.

Then there are more advanced filters.

Box 2: Visual

Once you drag to SKU to Visual level filter you should get Top N option.

Box 1: Using a workspace membership

Scenario:

The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.

Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.

Box 2: A mail-enabled security group

Scenario: Security Requirements

The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.

Box 1: A DAX Calculated measure

Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.

The following sample formula creates a measure that returns the end of the quarter, for the current context.

= ENDOFQUARTER(DateTime[DateKey])