Lessons

8 free lessons, then 51 in Pro, each checked cell by cell. Start at the top: every lesson builds on the one before.

Streak 0 daysPoints 0

Module 1 Foundations

Free

Measures, iterators, relationships, CALCULATE, ALL and context transition. 0 of 8 checked.

Foundations
01	Your first measure	SUM and the filter context of a matrix	SUM	Not started
02	Row by row with SUMX	Iterators and row context	SUMX	Not started
03	Reading across a relationship	RELATED inside an iterator	RELATED	Not started
04	Measures on measures	Reusing measures and DIVIDE	DIVIDE	Free account
05	CALCULATE with a filter	Changing the filter context with CALCULATE	CALCULATE	Free account
06	ALL and the share of total	Removing filters with ALL	ALL	Free account
07	ALLEXCEPT: share within a group	Keeping one filter while removing the rest	ALLEXCEPT	Free account
08	Context transition	Row context becoming filter context	FILTER, COUNTROWS	Free account

Module 2 Aggregations and iterators

Pro

Counting distinct things, averages per item, the largest line, and iterating with conditions. 0 of 7 checked.

Aggregations and iterators
09	Averages per customer with AVERAGEX over VALUES	Iterating a column, not a table	AVERAGEX, VALUES	Pro
10	Counting customers with DISTINCTCOUNT	Counting distinct values, not rows	DISTINCTCOUNT	Pro
11	Order lines per customer	A ratio of two counts	DIVIDE, COUNTROWS, DISTINCTCOUNT	Pro
12	The largest order line with MAXX	Iterators other than SUMX	MAXX	Pro
13	Counting rows that pass a test	COUNTROWS over FILTER	COUNTROWS, FILTER	Pro
14	Fix the margin	Sum of products, not product of sums	SUMX, RELATED	Pro
15	Sales per selling day	Iterating dates, skipping BLANK	AVERAGEX, VALUES	Pro

Module 3 Variables, blanks and conditions

Pro

VAR blocks, IF with a minimum, one value or none, tiers with SWITCH(TRUE()) and combined conditions. 0 of 5 checked.

Variables, blanks and conditions
16	Readable measures with VAR	Variables and RETURN	VAR, RETURN, DIVIDE	Pro
17	Only show reliable averages with IF	Returning BLANK on purpose	IF, COUNTROWS, AVERAGE	Pro
18	One value or nothing: SELECTEDVALUE	Measures that only make sense for one item	SELECTEDVALUE, HASONEVALUE	Pro
19	Tiers with SWITCH(TRUE())	Banding a measure	SWITCH, TRUE	Pro
20	Combining conditions with AND	Two tests in one FILTER	AND, FILTER, COUNTROWS	Pro

Pro

KEEPFILTERS, table filters versus column filters, REMOVEFILTERS, ALLSELECTED and context transition traps. 0 of 6 checked.

Filter context in depth
21	KEEPFILTERS and filter intersection	When a filter should not replace	CALCULATE, KEEPFILTERS	Pro
22	FILTER versus a column filter	Table filters and what they keep	CALCULATE, FILTER	Pro
23	Share of all customers with REMOVEFILTERS	Clearing a whole table’s filters	REMOVEFILTERS, DIVIDE	Pro
24	Share of the visible total with ALLSELECTED	Totals that respect slicers	ALLSELECTED, DIVIDE	Pro
25	Fix the best-customer measure	Context transition, in a bug hunt	MAXX, CALCULATE	Pro
26	Average monthly sales	Iterating months with a measure	AVERAGEX, VALUES	Pro

Module 5 Relationships

Pro

RELATEDTABLE, filtering a dimension by facts, inactive relationships and filter direction. 0 of 5 checked.

Relationships
27	Counting lines with RELATEDTABLE	From the one side to the many side	RELATEDTABLE, COUNTROWS, FILTER	Pro
28	Customers who bought a bike	Filtering a dimension by facts	CALCULATE, DISTINCTCOUNT	Pro
29	Sales by ship date with USERELATIONSHIP	Inactive relationships	CALCULATE, USERELATIONSHIP	Pro
30	Products per customer with CROSSFILTER	Filter direction	CALCULATE, CROSSFILTER, COUNTROWS	Pro
31	Average products per customer	Counting across a relationship	AVERAGEX, CALCULATE, DISTINCTCOUNT	Pro

Module 6 Time intelligence

Pro

A date table, year to date, last year, growth, previous month, rolling averages and running totals. 0 of 8 checked.

Time intelligence
32	Share of the year with a date table	Years, quarters and ALLEXCEPT on Date	ALLEXCEPT, DIVIDE	Pro
33	Year to date with TOTALYTD	Cumulative sales within a year	TOTALYTD	Pro
34	Year to date with CALCULATE and DATESYTD	Time filters as table filters	CALCULATE, DATESYTD	Pro
35	Last year with SAMEPERIODLASTYEAR	Comparing with the year before	CALCULATE, SAMEPERIODLASTYEAR	Pro
36	Year-over-year growth in percent	VAR, DIVIDE and last year	VAR, SAMEPERIODLASTYEAR, DIVIDE	Pro
37	Previous month with DATEADD	Shifting the date filter	CALCULATE, DATEADD	Pro
38	Rolling three months with DATESINPERIOD	Moving windows	CALCULATE, DATESINPERIOD, MAX	Pro
39	Running total over all dates	FILTER over ALL dates	CALCULATE, FILTER, ALL, MAX	Pro

Module 7 Ranking and top N

Pro

RANKX, ties, TOPN and the share of the best sellers. 0 of 4 checked.

Ranking and top N
40	Ranking products with RANKX	Ranks that respect the filter context	RANKX, ALL	Pro
41	Ranks inside a category, blank in subtotals	RANKX with ISINSCOPE	RANKX, ISINSCOPE, IF	Pro
42	Sales of the top 3 products with TOPN	Virtual top N tables	TOPN, SUMX	Pro
43	Share of the top 3	TOPN inside a ratio	VAR, TOPN, DIVIDE	Pro

Module 8 Virtual tables and segmentation

Pro

SUMMARIZE, ADDCOLUMNS, segments built from a virtual table, and calculation groups as a concept. 0 of 4 checked.

Virtual tables and segmentation
44	Average per customer and year with SUMMARIZE	Grouping in a measure	SUMMARIZE, AVERAGEX	Pro
45	Customers above average with ADDCOLUMNS	Virtual columns	ADDCOLUMNS, VALUES, FILTER, VAR	Pro
46	Sales from large customers	Dynamic segmentation	SUMX, FILTER, VALUES	Pro
47	Calculation groups, as a concept	One measure, many calculations	SWITCH, SELECTEDVALUE, TOTALYTD, SAMEPERIODLASTYEAR	Pro

Module 9 Common mistakes

Pro

Totals that don’t add up, the wrong table iterated, a filter that replaces, a blank that hides. 0 of 4 checked.

Common mistakes
48	Totals that don’t add up	Fix a product of two totals	SUMX	Pro
49	The wrong table iterated	Fix the granularity	AVERAGEX	Pro
50	Two filters on one column	Fix filters that cancel out	CALCULATE, IN	Pro
51	Customers without sales	Fix: what isn’t in the facts	FILTER, ISBLANK, COUNTROWS	Pro

Module 10 PL-300 practice test

Pro

Eight exam-style tasks across every module, checked cell by cell. 0 of 8 checked.

PL-300 practice test
52	PL-300 practice 1: margin by segment	Exam-style task: ratios of measures	DIVIDE	Pro
53	PL-300 practice 2: share of category	Exam-style task: ALLEXCEPT	ALLEXCEPT, DIVIDE	Pro
54	PL-300 practice 3: year to date	Exam-style task: time intelligence	TOTALYTD	Pro
55	PL-300 practice 4: growth versus last year	Exam-style task: SAMEPERIODLASTYEAR	SAMEPERIODLASTYEAR, DIVIDE, VAR	Pro
56	PL-300 practice 5: top products	Exam-style task: TOPN	TOPN, SUMX	Pro
57	PL-300 practice 6: active customers	Exam-style task: counting with a measure test	COUNTROWS, FILTER, CALCULATE	Pro
58	PL-300 practice 7: ship date analysis	Exam-style task: USERELATIONSHIP	CALCULATE, USERELATIONSHIP	Pro
59	PL-300 practice 8: high-value customers	Exam-style task: segmentation	COUNTROWS, FILTER, VALUES	Pro

Pro: 51 lessons today, plans and prices