SQLBI Newsletter #248

NEW ARTICLE

Comparing different school terms in Power BI

This article describes how to implement a comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns.
Read more

SQLBI+ UPDATE

New content on SQLBI+

We made a second draft of the DAX window functions whitepaper available to SQLBI+ subscribers. We cover new functions and rewrote the description of "apply semantics".
Read more

#248 · Aug 2023

LEARNING

Course calendar

Mastering DAX

	Sep 19-21 - Amsterdam
	Sep 27-29 - Chicago
	Nov 1-3 - Palo Alto
	Nov 6-8 - Atlanta
	Dec 5-7 - Cologne

Data Modeling

	Nov 7-9 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	DAX Patterns

PREVIEW

The research phase: laying the groundwork for DAX Optimizer

We continue to tell the story of DAX Optimizer: in this installment, we describe the blood, sweat, and code that went into turning this idea into a reality.
The pace of beta access will pick up soon. Waitlist is open.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Exploring Power BI import mode throughput with Log Analytics This series of articles explains how to use Log Analytics to estimate the refresh throughput of models published on Power BI service. Jul 23, 2023 · Chris Webb
	• On-premises data gateway July 2023 release Once a month, we struggle to find space for data gateway update news. But that’s oxygen for this section in the slow summer months of the northern hemisphere! Jul 19, 2023 · Microsoft
	• Bar Charts in Power BI The new Power BI Project format (.pbip) simplifies the sharing of report parts you can review and share. We need more tools to automate the process, but we already have valuable content to reuse, like templates for bar charts that look good. Jul 26, 2023 · Kurt Buhler
	• Basic Line Charts in Power BI A second set of templates is also available to create better line charts in Power BI. Jul 29, 2023 · Kurt Buhler

SQLBI YOUTUBE CHANNEL