SQLBI Newsletter #221

NEW ARTICLE

Rolling average with working days in DAX

Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days.
Read more

NEW VIDEO SERIES

The Whiteboard video series on the SQLBI YouTube channel

The Whiteboard is a new series on the SQLBI YouTube channel where we use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way.
Read more

#221 · Jul 2022

LEARNING

Course calendar

Mastering DAX

	Aug 29-31 - Munich
	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - 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
	Power Pivot

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI July 2022 update The July update of Power BI brings a new NETWORKDAYS function in DAX (already documented in our DAX Guide) and several improvements to map visuals, metrics, and DirectQuery performance with RLS. Jul 14, 2022 · Microsoft
	• Measuring Power Query CPU usage during Power BI dataset refresh You can measure which portion of a dataset refresh time is caused by the data source and which portion by the Power Query mashup engine. This could be important if you run on Premium because you drain quotas of the CPU available. Jul 3, 2022 · Chris Webb
	• User learning paths for successful Power BI self-service There are different dimensions and different approaches to learning self-service tools in Power BI. Every user in a company may customize their effort depending on their goals and mindset. Jun 21, 2022 · Kurt Buhler

SQLBI YOUTUBE CHANNEL

Latest videos

Hiding measures by using object level security in Power BI

15:33

#article

Marco Russo

EVALUATE, ORDER BY

01:34

#daxguide

Alberto Ferrari

Filter Context - The Whiteboard #01

08:21

#thewhiteboard

Marco Russo

View Web Version · Status & Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.