SQLBI Newsletter #126

NEW ARTICLE

Understanding numeric type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more »

COURSES HIGHLIGHT

Learning DAX and data modeling in 2019

We published many dates of courses in 2019. In the next two weeks we will publish additional dates in Europe (May-July), North America (May-June), and Australia (July-August).

Don't miss the early bird offer for the first Mastering DAX courses of the year:

• Seattle, WA, US – Feb 6-8
• Atlanta, GA, US – Feb 11-13
• Amsterdam, NL – Feb 19-21
• London, UK – Mar 13-15
• Vancouver, BC, CA – Mar 13-15

#126 – Dec. 2018

DATA MODELING

	Mar 25-27 - Chicago
	May 8-10 - Amsterdam

MASTERING DAX

	Dec 11-13 - Zurich
	Feb 6-8 - Seattle
	Feb 11-13 - Atlanta
	Feb 19-21 - Amsterdam
	Mar 13-15 - London
	Mar 13-15 - Vancouver
	Apr 9-11 - Amsterdam
	Jun 18-20 - Aarhus

VIDEO COURSES

	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	SSAS Tabular
	Power Pivot

NEWS DIGEST

Latest news on Power BI

	• Power BI Dataflows FAQ Matthew Roche created a page with the frequently asked questions (FAQ) about Power BI Dataflows. This new feature is still in preview and will have a big impact in solutions based on Power BI, but it is also frequently confused or misunderstood. This page helps in clarifying many doubts, and if you need more details the Matthew's blog has many articles describing both the architecture and the implementation of Power BI dataflows in more details. Read more »
	• Implementing basic query folding on a web service in Power Query/M and Power BI If you import data from a web service that provides advanced filtering capabilities, Chris Webb describes how to implement query folding in the connection. Advanced content to improve performance in otherwise slow scenarios. Read more »
	• Learn DAX at SqlBits 2019 Alberto Ferrari and Marco Russo will be teaching DAX at SqlBits 2019 in Manchester, UK. If you are new to DAX you can attend the From 0 to DAX training day (by Alberto) on Feb. 27. If you are already confident with DAX, you can go straight to the Advanced DAX day (by Marco) on Feb. 28.

SQLBI REPLAY - OCT 10, 2013

Semi-Additive Measures in DAX

Values such as inventory and balance account, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX through several examples. Read more »

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy