SQLBI Newsletter #225

NEW ARTICLE - DAX 101

ALLSELECTED is an extremely complex function to use in DAX. In this article, we provide an introduction to ALLSELECTED and its main use cases.
Read more

DAX PATTERNS

Standard time-related calculations

In this pattern, we show you how to compute time-related calculations, like year-to-date, same period last year, and percentage growth using a standard calendar.
Read more

#225 · Sep 2022

LEARNING

Course calendar

Mastering DAX

	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago
	Nov 28-30 - Amsterdam
	Mar 21-23 - Dallas

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

	• Public preview of Multiple Audiences for Power BI Apps With multiple audiences for an App, Power BI authors can now create multiple audience groups within the same App and assign different permissions to each group. Microsoft shows the feature with a few examples and screenshots. Aug 24, 2022 · Microsoft
	• Exploring App Audiences in Power BI Yes, that's two pieces of news about the same topic... Because well, this article better explains what the feature does, when it should be used, and how. Just in case the announcement didn't impress you, check this out. Sep 6, 2022 · Kurt Buhler
	• Matrix Multiplication using DAX You might think that DAX is not the right language to perform calculations over a matrix, and that nobody would ever attempt to do so. Well, not only did someone explore that challenge, but he also found a way to do it! Aug 28, 2022 · Sergio Murru
	• Power BI Dataset Checklist Last but not least, save this link: it is a complete checklist for your dataset. It helps ensure you have a clean Power BI dataset that follows the best practices. Future you is going to love the fact that present you bookmarked this link! Aug 30, 2022 · Kurt Buhler

SQLBI YOUTUBE CHANNEL