SQLBI Newsletter 3/2018

NEW ARTICLE

ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED.
Read more »

NEW BLOG POST

The new Data Modeling for Power BI course

Marco Russo describes the content and who should attend the new Data Modeling for Power BI course based on the book Analyzing Data with Power BI and Power Pivot. First dates announced in Europe, United States, and Australia. Read more »

COURSES HIGHLIGHT

New courses in Australia

SQLBI classes are coming back in Australia:

• Brisbane – July 18-20 – Mastering DAX
• Sydney – July 24-26 – Mastering DAX
• Melbourne – July 31-August 2 – Mastering DAX
• Sydney – August 7-9 – Data Modeling for Power BI
• Perth – August 20-22 – Mastering DAX

Are you in US or Europe? Don't miss the early bird discount for New York and Amsterdam classes in March - it exprires in a few days!

BI NEWS DIGEST

Power BI Desktop February update, On-premises data gateway, and more...

	• Power BI Desktop February update Power BI Desktop February 2018 update is available, and this is a huge update. The two most important features are certainly multiple selection across multiple charts and slicers synchronized across multiple pages. But there are many other improvements like DirectQuery performance optimization and the long-awaited Mark as Date table feature. Read more »
	• Fun with graphing in Power BI Greg Deckler wrote a series of article describing how to push the limits of Power BI displaying graphs. It requires to really think out of the box to write DAX measures that plot Cartesian parametric equations. Very instructive! Read more »
	• Creating Excel “Data Dump” reports from Power BI If you need to dump data from Power BI to Excel and Export Data is not enough because of its limitation, read how to solve the problem using DAX queries (from Chris Webb blog). Read more »
	• DAX IF & Switch statement performance Roman Lánský compared IF and SWITCH performances in DAX. The result is not a simple answer. As usual, it depends. Read more »
	• On-premises data gateway January update If you use the Data Gateway for Power BI, watch out the January 2018 update. Yes, there is still no February update for this. Read more »
	• Using SSAS Multidimensional as a data source for Power BI Chris Webb explained at PASS Summit how to use SSAS Multidimensional as a data source for Power BI. If you have this mixed scenario, you might want to watch his video. Watch now »

SQLBI REPLAY - AUG 30, 2015

Row Context and Filter Context in DAX

Understanding the difference between row context and filter context is important in using DAX correctly. This article introduces these two concepts. Read more »