SQLBI Newsletter #173

NEW ARTICLE

Understanding the difference between LASTDATE and MAX in DAX

This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX.
Read more

#173 · Sep 2020

LEARNING

Course calendar

video courses

	DAX Patterns collection
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

Classroom courses

Check out the latest updates on our training page.

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

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI Paginated Reports August 2020 updates The latest version of Power BI Report Builder supports multi-value parameters for DAX, a new authentication type for Azure SQL DB and Azure Synapse, and Common Data Service data sources. This (paginated report) is no legacy technology at all! Sep 4, 2020 · Microsoft
	• MDX Studio The new release of MDX Studio now has a single EXE to copy, several bug fixes, and a notification of new versions available. Thanks Alberto Spelta for working on version 0.4.50! Sep 13, 2020 · SQLBI
	• Power Query M Primer: Type System If you are serious about Power Query, you cannot miss this series of articles explaining how M works from the ground up. Previous articles in the series cover functions, variables, types, tables, and error handling. Sep 3, 2020 · Ben Gribaudo
	• Tabular Editor 2.12.3 Since our latest newsletter, two updates of Tabular Editor were released with several fixes and new features for scripts. Sep 11, 2020 · Daniel Otykier
	• Optimizing the performance of Power Query merges in Power BI, part 5: cross joins The latest part of the series dedicated to optimizing the merge operation in Power Query describes how to obtain a cross join in an efficient way. Aug 30, 2020 · Chris Webb

View Web Version · Change Email 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.