Free PL-300 Practice Exam

Get Ready Smarter for the PL-300 Exam with Our Free and Reliable PL-300 Exam Questions – Updated for 2025.

At Cert Empire, we focus on providing the most accurate and up-to-date exam questions for students preparing for the Microsoft PL-300 Exam. To make preparation easier, we’ve opened parts of our PL-300 study resources free for everyone. You can practice as much as you need with Free PL-300 Practice Test.

Get PL-300 Exam Dumps

Microsoft PL-300 Free Exam Questions

Disclaimer

Please keep a note that the demo questions are not frequently updated. You may as well find them in open communities around the web. However, this demo is only to depict what sort of questions you may find in our original files.

Nonetheless, the premium exam dumps files are frequently updated and are based on the latest exam syllabus and real exam questions.

1 / 59

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and
Delivery Date.
Does this meet the goal?

Yes

2 / 59

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?

Yes

3 / 59

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a report-level filter that filters based on the order date.
Does this meet the goal?

Yes

4 / 59

You have a Power BI report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.
The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals.
What should you do?

Merge Suppliers and LineItems

Remove the LineItems[Description] column

Remove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month

Group LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price]

5 / 59

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.
What should you do to ensure that the locations are mapped properly?

Set the data category of City, State/Province, and Country

Change the data type of City, State/Province, and Country

Set Summarization for City, State/Province, and Country to Donג€™t summarize

Create a calculated column that concatenates the values in City, State/Province, and Country

6 / 59

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?

Yes

7 / 59

In Power BI Desktop, you have a dataset that contains a table.
You create a table visual on a Power BI report page as shown in the following exhibit.

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.
What should you do?

Set the Data type of the Plant Image field to Binary

Set the Data category of the Plant Image field to Web URL

Set the Data category of the Plant Image field to Image URL

From the Formatting tab, select Values, and then set URL icons to On for the table

8 / 59

You are creating a Power BI report by using Power BI Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?

Q&A

Smart narrative

Key influencers

Decomposition tree

9 / 59

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.
You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.
What should you do?

Select the column chart and set the donut chart interaction to None

Select the donut chart and set the column chart interaction to None

Select the column chart and set the donut chart interaction to Filter

Select the donut chart and set the column chart interaction to Filter

10 / 59

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

Create a horizontal line that has a fixed value of 24,000

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile

Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40)

Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,sales[Total Sales],0.40)

11 / 59

You are creating a dashboard by using the Power BI service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?

Pin each chart as a tile

Pin the report page as a live tile

Edit the dashboard theme and pin each chart as a tile

Edit interactions in the report and set all interactions to Filter

12 / 59

You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort:
✑ For values that are greater than or equal to 100, the font of the data label must be dark red.
✑ For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?

Rules

Color scale

Field value

13 / 59

You build a report to help the sales team understand its performance and the drivers of sales.
The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?

Q&A

Funnel chart

Key influencers

Line and clustered column chart

14 / 59

You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

Line chart

Donut chart

Waterfall chart

Stacked area chart

15 / 59

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?

filter

highlight

no impact

16 / 59

You use Power Query Editor to preview a query that contains sales order data in the following columns:

• Tax Amount
• Sales Order ID
• Freight Amount
• Subtotal Amount
• Total Item Quantity

The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount.

You need to query the data to identify the following metrics by month:

• The average item quantity per order
• The average freight amount per order
• The maximum item quantity per order

How should you modify the query?

In the Freight Amount column, replace the null values with 0

In the Total Item Quantity column, replace the null values with 0

In the Tax Amount column, remove rows that contain null values

In the Freight Amount column, remove rows that contain null values

17 / 59

You have a Power BI model that contains a table named Employees. The table contains the following columns:

• Employee ID
• First Name
• Last Name
• Department
• Salary

Each employee is uniquely identified by using Employee ID.

You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.

Which DAX expression should you use?

AVERAGE(‘Employees’[Salary])

DISTINCTCOUNT(‘Employees’[Salary])

CALCULATE(AVERAGE(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)

CALCULATE(DISTINCTCOUNT(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)

18 / 59

You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount.

You need to create the visual shown in the following exhibit.

In which section of the Fields well should you place the measures?

Rows

Columns

Values

Drill through

19 / 59

You are reviewing a Power BI data model.

You have a calculated table that has the following definition.

ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )

You need to identify the results of the DAX expression.

Which rows will be returned in ProductList?

All the rows in both tables

All the rows in ProductsGroupB that have a matching row in ProductsGroupA

All the rows in ProductsGroupA that have no matching row in ProductsGroupB

All the rows in ProductsGroupA that have a matching row in ProductsGroupB

20 / 59

You have a Power BI 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?

TOTALQTD ( [Total Sales], Date[Date] )

CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )

CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )

CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )

21 / 59

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date
• Order Date
• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

Yes

22 / 59

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.

You need to shape the query to display the following three columns:

• Month
• Sales
• Year

What should you select in Power Query Editor?

Pivot column

Unpivot columns

Transpose

Merge columns

23 / 59

You have a Power BI model that contains a table named Date. The Date table contains the following columns:

• Date
• Fiscal Year
• Fiscal Quarter
• Month Name
• Calendar Year
• Week Number
• Month Number
• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.

Which DAX function should you include in the table definition?

CALCULATE

SUMMARIZE

ADDCOLUMNS

DATATABLE

24 / 59

You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

CountRows('Sales')

Count('Sales'[Order ID])

CountA('Sales' [Order ID])

DistinctCount('Sales' [Order ID])

25 / 59

You have a Power BI data model that contains a table named Employees. The table has the following columns:

• Employee Name
• Email Address
• Start Date
• Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

• Users must see only their own employee data.
• The DAX expression must work in both Power BI Desktop and the Power BI service.

Which expression should you use?

[Email Address] - USERNAME()

[Employee Name] = USERNAME()

[Email Address] = USERPRINCIPALNAME()

[Employee Name] - USERPRINCIPALNAME()

26 / 59

You have a Power BI model that contains a table named Employee. The table contains the following data.

Each employee has one manager as shown in the ParentEmployeeID column.

All reporting paths lead to the CEO at the top of the organizational hierarchy.

You need to create a calculated column that returns the count of levels from each employee to the CEO.

Which DAX expression should you use?

PATH(Employee[EmployeeID],Employee[ParentEmployeeID])

PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))

PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)

PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)

27 / 59

From Power Query Editor, you profile the data shown in the following exhibit.

The IoT GUID and IoT ID columns are unique to each row in the query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You split the IoT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

Yes

28 / 59

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

Yes

29 / 59

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

Yes

30 / 59

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?

Yes

31 / 59

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

one-to-one between Customer and Transaction

one-to-many from Transaction to Customer

one-to-many from Customer to Transaction

many-to-many between Customer and Transaction

32 / 59

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.
Each sales region has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?

Publish the reports to a different workspace other than the one hosting the datasets

Publish the reports in an app and grant the HR managers access permission

Add the HR managers as members of the existing workspace that hosts the reports and the datasets

Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace

33 / 59

You use Power BI Desktop to import two tables named Customer and Contacts.

The Customer table contains the following columns:

• Customer_Name
• Customer ID
• Website

The Contacts table contains the following columns:

• Contact ID
• Contact Email
• Contact Name
• Customer Name

A web-based contact form is used to fill the Contacts table. The data is not sanitized.

You need to create a merge for the Customer and Contacts tables.

What should you do?

Enable fuzzy matching

Disable fuzzy matching

Set Join Kind to Left Outer

34 / 59

You use Power Query Editor to preview a column named Date as shown in the following exhibit.

You need to change the Date column to contain only the year. The solution must minimize administrative effort.

What should you do?

Split the column by delimiter

Extract the text after the delimiter

Split the column by number of characters

Transform the column to contain only the year

35 / 59

You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

• Use Analytics views.
• Filter data from the cloud.

Which connector should you use?

OData Feed

OData queries

Azure DevOps (Boards only)

Azure DevOps Server (Boards only)

36 / 59

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required type.

Does this meet the goal?

Yes

37 / 59

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Web, Excel Workbook

SharePoint folder, Web

Folder, SharePoint folder

Text/CSV, Folder

Excel Workbook, Text/CSV

38 / 59

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

Add a SQL statement

Set Data Connectivity mode to Import

Set Data Connectivity mode to DirectQuery

Set the Command timeout in minutes setting

39 / 59

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

Change the data type of the Logged column to Date

Split the Logged column by using at as the delimiter

Apply a transformation to extract the first 11 characters of the Logged column

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date

40 / 59

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

Merge the Customer and Address tables

Append the Customer and Address tables

Transpose the Customer and Address tables

Group the Customer and Address tables by the Address ID column

41 / 59

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?

Dataflows

Dataverse

SQL Server database

Microsoft Teams Personal Analytics

42 / 59

You are building a Power BI report that uses data from an Azure SQL database named erp1.
You import the following tables.

You need to perform the following analyses:
✑ Orders sold over time that include a measure of the total order value
Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report.
What should you do first?

Calculate the count of orders per product by using a DAX function

From Power Query, merge the Orders query and the Order Line Items query

From Power Query, merge the Order Line Items query and the Products query

Create a calculated column that adds a list of product categories to the Orders table by using a DAX function

43 / 59

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

Create an active relationship between the tables and select Assume referential integrity

Create an inactive relationship between the tables and select Assume referential integrity

Create an active relationship between the tables and select Apply security filter in both directions

Create an inactive relationship between the tables and select Apply security filter in both directions

44 / 59

You have the Power BI model shown in the following exhibit.

There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

Create a slicer that filters Departments based on DepartmentID

Create a DepartmentID parameter to filter the Departments table

To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function

Create a row-level security (RLS) role for each department, and then define the membership of the role

45 / 59

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

Enable visual interactions

Split the visuals onto multiple pages

Replace the default visuals with AppSource visuals

Change any DAX measures to use iterator functions

46 / 59

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and
Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.

Date[Calendar Year] = 2020 -
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

The user will only see data for which the State Province value is Kentucky

The user will receive an error and will not be able to see the data in the report

The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020

The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020

47 / 59

You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

From Power Query Editor, add a column that calculates the length of col1

In the report, add a DAX function that calculates the average length of col1

In the report, add a DAX calculated column that calculates the length of col1

From Power Query Editor, change the distribution for the Column profile to group by length for col1

48 / 59

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

Admin

Member

Viewer

Contributor

49 / 59

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

Remove the Subject and Body columns during the import

From Model view, set the Subject and Body columns to Hidden

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent

50 / 59

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You change the semantic model mode.

Does this meet the goal?

Yes

51 / 59

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You normalize casing in the source query or Power Query Editor.

Does this meet the goal?

Yes

52 / 59

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You add an index key and normalize casing in the data source.

Does this meet the goal?

Yes

53 / 59

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized.

What should you do in Power Query Editor?

Select Keep Errors

Select Remove Errors

Edit the query in the Query Errors group

Select Replace Errors

54 / 59

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Combine files

Append queries

Merge queries

55 / 59

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The
Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
✑ Minimize online processing operations.
✑ Minimize calculation times and render times for visuals.
✑ Include data from the current year, up to and including the previous day.
What should you do?

Create a dataflows connection that has DirectQuery mode selected

Create a dataflows connection that has Import mode selected and schedule a daily refresh

Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset

Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly

56 / 59

You attempt to connect Power BI Desktop to a Cassandra database.

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

ODBC

OData

OLE DB

Microsoft SQL Server database

57 / 59

You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

Get data from a SharePoint list, enter the site URL, and then select Combine & Load

Get data from a SharePoint folder, enter the site URL, and then select Combine & Load

Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library

Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library

58 / 59

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The solution must minimize development effort.
Which type of data source should you use?

A SharePoint folder

Power BI dataflows

An Excel workbook

Power BI dataset

59 / 59

You have the Power BI data model shown in the following exhibit.

The Sales table contains records of sales by day from the last five years up until today’s date.
You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.
Which DAX expression should you use?

SUM(Sales[Sales])

TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )

Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])

Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

Your score is

The average score is 69%

By Wordpress Quiz plugin

Free PL-300 Practice Exam – 2025 Updated

Get Ready Smarter for the PL-300 Exam with Our Free and Reliable PL-300 Exam Questions – Updated for 2025.

Disclaimer

[email protected]

Helpful links

top Vendors

Contact Us

[email protected]

FLASH OFFER

avail $6 DISCOUNT on YOUR PURCHASE