PL-300 Exam Guide: Skills, DAX and 6-Week Plan

Three of the four PL-300 skill areas carry almost the same weight, at 25–30% each. That means you cannot pass by polishing reports while skipping data prep or modeling. Pass the exam and you earn Microsoft Certified: Power BI Data Analyst Associate.

Below you get the skills table, the exam format, prices and refund terms, a weekly study plan and a DAX example you can build in minutes.

What the certification proves and who it fits

Microsoft rates this credential at the Intermediate level, for the Data Analyst role. It shows you can model, visualize and analyze data with Power BI in a way that meets business and technical requirements. See the official certification page.

Microsoft expects you to do two things well:

• Deliver meaningful business value through easy-to-understand visualizations.

• Enable others to perform self-service analytics.

You should be proficient with Power Query and Data Analysis Expressions (DAX). In the job, you work with business stakeholders on requirements and with analytics engineers and data engineers to find and get data.

This exam fits report builders, business analysts and finance or operations staff who live in spreadsheets. It also suits junior BI developers who want proof of skills.

Skills measured and their weights

The weights below come from the official study guide, skills measured as of April 20, 2026.

Here is what sits inside each area:

• Prepare the data: connect to sources, choose between DirectLake, DirectQuery and Import, profile and clean data, pivot and unpivot, merge and append queries, build fact and dimension tables.

• Model the data: relationships, cardinality and cross-filter direction, a common date table, CALCULATE, time intelligence, semi-additive measures, calculation groups, Performance Analyzer.

• Visualize and analyze: choose visuals, conditional formatting, bookmarks, drillthrough, sync slicers, accessibility, AI visuals, forecasting, outlier detection, plus Copilot tasks such as creating a narrative visual or a new report page.

• Manage and secure: workspaces and apps, gateways, scheduled refresh, certifying content, workspace roles, row-level security, sensitivity labels.

Microsoft notes that the bullets illustrate how skills are assessed, and related topics may appear.

Exam format at a glance

You can try the question interface first in the exam sandbox, linked from the official page. It is a free way to avoid surprises on exam day.

If the exam is not offered in your language, Microsoft says you can request an additional 30 minutes. Accommodations are also available for assistive devices or extra time.

Microsoft recommends registering with a personal Microsoft account, not a work or school account. Records tied to an organizational account are lost if you leave that organization and cannot be recovered.

What it costs: list price, our voucher, validity and refunds

Microsoft's list price is $165.00 USD (Microsoft official exam price, as published by the vendor). Microsoft sets the price by the country or region where you take the exam, so your local price may differ.

Our PL-300 voucher costs $44.99. The voucher is valid for 12 months and is redeemed with Pearson VUE.

Here is how delivery and refunds work:

1. We email the voucher code within 12 hours of payment. It also appears in your account.

2. You can cancel for a full refund before the code is delivered.

3. A delivered code is non-refundable, unless the test provider rejects it as invalid, already used or expired on first use.

4. In that case, contact support within 14 days with your order number and a screenshot. We replace or refund the code.

Full terms are on the refund page and the delivery page.

Buy only when your study plan is on track. The 12-month window is generous, but a code you never use is wasted money.

A 6-week study plan with weekly hours

This plan assumes you have used Power BI a little. The hours are our suggestion, not a Microsoft figure. Add two weeks if you are new to DAX.

Study in this order:

1. Read the skills list in the study guide and mark each line green, yellow or red.

2. Build a small report from scratch each week. Hands-on work sticks better than watching videos.

3. Take the Practice Assessment on AI Skills Navigator. Microsoft says it more closely matches the exam experience.

4. Spend the final days on your red items, not on topics you already know.

Microsoft also offers exam prep videos with tips and strategies. They are linked from the official page.

Worked example: a date table and time intelligence

Time intelligence appears in the modeling skills, and it trips up many people. Start with a date table, then build measures on top of it.

Date = CALENDAR(DATE(2022,1,1), DATE(2026,12,31))

Sales Amount = SUM(Sales[Amount])

Sales YTD = TOTALYTD([Sales Amount], 'Date'[Date])

Sales Last Year =
CALCULATE([Sales Amount], SAMEPERIODLASTYEAR('Date'[Date]))

After you create the table, mark it as a date table and relate 'Date'[Date] to the date column in Sales. Then drop both measures into a line chart by month.

Try three variations on your own:

• Break the relationship and see what the measures return.

• Change the cross-filter direction and watch totals shift.

• Open Performance Analyzer and check which visual is slowest.

Each one maps to a line in the skills list.

Mistakes that commonly cost points

• Using old material. The skills list is dated April 20, 2026. The current list includes Copilot tasks, visual calculations and a choice between DirectLake, DirectQuery and Import. Older courses may skip these.

• Trusting the legacy practice test. Microsoft says legacy Practice Assessments on Learn are no longer updated and recommends the new experience.

• Skipping modeling. Prepare, model and visualize each carry 25–30%. Weak DAX hurts you in two areas.

• Ignoring the Manage and secure area. At 15–20%, row-level security and workspace roles can decide a close result.

• Never seeing the interface. Launch the exam sandbox before test day so the question types feel familiar.

• Memorizing answers. Questions test choices in scenarios. Know why you pick a relationship type or a distribution method.

After you pass: renewal and next steps

This certification expires unless you renew it. The renewal frequency is 12 months. Microsoft lets you renew at no cost by passing an online assessment on Microsoft Learn.

Set a calendar reminder a few months before expiry. Share your credential through your Microsoft Learn profile, where you can also print your certificate.

If you want to go deeper, our DP-600 guide on Fabric skills covers a natural next step in the analytics path. For a gentler start, read the DP-900 guide first.

When your plan is ready, you can get the PL-300 voucher here.

Sources

• Microsoft Certified: Power BI Data Analyst Associate

• Study guide for Exam PL-300: Microsoft Power BI Data Analyst