PL-300: Microsoft Power BI Data Analyst
You need to create a relationship between two tables named Sales and Sales Detail in a Power BI data model. For every row in the Sales table, there is at least one row, and possibly multiple rows, in the Sales Detail table.
How should you configure the relationship?
one-to-one from Sales to Sales Detail
one-to-many from Sales to Sales Detail
many-to-many from Sales to Sales Detail
many-to-one from Sales to Sales Detail
You have a Power BI data model that has the following tables: Sales, Returns, Customer, and Date. No relationships have been created.
You need to view and filter sales and returns by the same months at the same time.
What three actions should you perform? Each correct answer presents part of the solution.
Create a DAX measure that combines sales and returns.
Create a month column in both the Sales and Returns tables.
Create a relationship between Sales and Date.
Create a relationship between the Returns and Date.
Select the Date table and select Mark as date table.
Answers are;
1-Create a month column in both the Sales and Returns tables.
2- Create a relationship between Sales and Date.
3-Create a relationship between the Returns and Date.
Which are calculated on demand?
Calculated columns
Calculated tables
Measures
Answer is Measures
Which are calculated based on the filters that are used by the report user? Calculated columns or measures?
Measures
Calculated columns
Answer is Measures
Which DAX function evaluates an expression in a modified filter context?
SUMX
CALCULATE
ALL
Answer is CALCULATE
Why would you want to override the default context?
To create measures that behave according to the user’s selection
To create measures that behave according to your intentions, regardless of what the user selects
Answer is To create measures that behave according to your intentions, regardless of what the user selects
What type of Measure uses SUM to aggregate over one set of dimensions and a different aggregation over a different set of dimension?
Additive
Aggregate
Semi-additive
Answer is Semi-additive
What type of functions enable you to manipulate data using time periods?
Time intelligence
Comparer functions
Value functions
Answer is Time intelligence
Which two functions will help you compare dates to the previous month?
TOTALYTD and PREVIOUSMONTH
CALCULATE and TOTALTYD
CALCULATE and PREVIOUSMONTH
Answer is CALCULATE and PREVIOUSMONTH
You have an API that returns more than 100 columns. The following is a sample of column names.
- client_notified_timestamp
- client_notified_source
- client_notified_sourceid
- client_notified_value
- client_responded_timestamp
- client_responded_source
- client_responded_sourceid
- client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code?
To answer, select the appropriate options in the answer area.
Box 1: Table.RemoveColumns
When you do Remove Columns Power Query uses the Table.RemoveColumns function
Box 2: List.Select
Get a list of columns.
Box 3: Text.EndsWith
Reference:
https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657