See the latest Power BI and SSAS news.
View this newsletter in your browser


Using CONCATENATEX in measures

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure.
Read more »



Introducing Calculation Groups

This article is the first of a series dedicated to calculation groups in DAX. This introduction explains the capabilities of this feature and how to create calculation groups in a Tabular model. Read more »



Upcoming courses

• Learn DAX in Australia:

  Brisbane, AU – July 17-19 Early Bird expiring soon

  Sydney, AU – July 30-Aug 1

  Melbourne, AU – Aug 6-8

  Perth, AU – Aug 14-16

• Learn data modeling for Power BI:

  Melbourne, AU – July 23-25 Early Bird expiring soon

  San Francisco, US – Oct 30-Nov 1

  Amsterdam, NL – Nov 26-28

• Other Mastering DAX dates for September-December: Chicago, Denver, Washington, Amsterdam, Copenhagen, and more to come.



Latest news on BI

• Power BI announcements and roadmap at MBAS 2019
If you missed the Power BI keynote at Microsoft Business Applications Summit, Gilbert Quevauvilliers wrote a recap article full of screenshots providing the essential information about new features and roadmap.
Read more »
• Sessions recorded at MBAS 2019
All the keynotes and sessions of the last Microsoft Business Applications Summit are available on-demand - and are free! Watch now »
• Issues when creating reports in Power BI Services vs. Desktop
Melissa Coates describes possible downsides when creating a report in Power BI Services instead of Power BI Desktop, which does not have the issues described in the article. Read more »
• M folding in the enhanced engine of Power BI Dataflows
Another precious article by Cristian Petculescu describes the enhanced engine of Power BI dataflows, explaining in detail how the query folding works and the syntax that is supported. Read more »