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.

"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.

DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.

rence:

https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

Box 1: The Viewer role to the workspace

The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.

Box 2: Build

The analysts must be able to build new reports from the dataset that contains the profit and loss data.

Scenario: The reports must be made available to the board from powerbi.com.

The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

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])