SQLBI Newsletter 11/2018

NEW ARTICLE

Optimizing IF conditions using variables

This article describes a very common optimization pattern using variables to optimize conditional expressions in DAX. Read more »

NEW POST

Time intelligence issues in DAX for fiscal years starting in March

If you have a fiscal year starting in March, you can have a problem using the time intelligence functions in DAX. Read more »

NEW POST

Change culture/collation of an Analysis Services Tabular database

When you create a Tabular model for Analysis Services, the Culture and Collation properties are set automatically and cannot be changed by the SSDT user interface. Read more »

DATA MODELING

	Jun 26-28 - Amsterdam
	Aug 7-9 - Sydney
	Oct 10-12 - London
	Nov 28-30 - New York

MASTERING DAX

	Jun 13-15 - Chicago
	Jun 19-21 - Vienna
	Jul 2-4 - Amsterdam
	Jul 18-20 - Brisbane
	Jul 24-26 - Sydney
	Jul 31/Aug 2 - Melbourne
	Aug 20-22 - Perth
	Oct 1-3 - San Francisco
	Nov 20-22 - London
	Dec 3-5 - Miami

OPTIMIZING DAX

	Jul 5-6 - Amsterdam

VIDEO COURSES

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

COURSES HIGHLIGHT

Next courses

	July and August in Australia: • Brisbane, Sydney, Melbourne, and Perth (Mastering DAX) • Sydney (Data Modeling for Power BI)
	Last DAX courses in Europe before summer: • Vienna (Mastering DAX) • Amsterdam (Mastering DAX)

Look at new dates in San Francisco, London, New York, Miami (and other cities coming soon!)

NEWS DIGEST

Latest news on Power BI

	• On-premises data gateway May update The May update of the On-Premises Data Gateway is available. New features for single sign-on (SSO) support, and mashup engine synchronized with the Power BI Desktop version. Read more »
	• Power BI desktop supports connecting to a diagnostics port Power BI Desktop now officially supports external connections for diagnostics purposes. Translation: Microsoft support employees now can suggest to use tools like DAX Studio and VertiPaq Analyzer. Read more »
	• Using email attachments as a data source in Power BI Chris Webb explains how to use files received by email as a data source in Power BI. This is a nice technique to automate the process of Excel/CSV files you receive every month in your inbox. Read more »

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