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


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
SQLBI+ Inside Calculation Groups

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


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

Latest videos
Filtering calculation items in a slicer
11:24#articleAlberto Ferrari
The Making of Optimizing DAX Second Edition - Unplugged #53
24:29#unpluggedAlberto Ferrari & Marco Russo