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


Optimizing IF and SWITCH expressions using variables

This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. Read more »



Don't miss our last classes of the year!

Last seats for Mastering DAX in Boston and Houston.

• Mastering DAX: Boston - Oct 31-Nov 2
• Mastering DAX: Houston - Nov 13-15
• Mastering DAX: Miami - Dec 3-5
Last seats
Last seats
• Mastering DAX: London - Nov 20-22 Early Bird Expiring

Early Bird expiring for the last Data Modeling for Power BI of the year.
• Data Modeling: New York - Nov 28-30 Early Bird Expiring



Latest news on Business Intelligence

• Power BI Desktop October 2018
This month the Power BI Desktop update introduced several improvements and new features. Power Query now has data profiling and fuzzy matching options. While a 11-line window does not qualify as an editor in 2018, we can say the new DAX editing experience is a welcome step forward. A real editor window is coming? We hope so. enabled composite models and aggregation support in the Power BI service. Read more »
• Power BI Service supports composite models and aggregations
The composite models and aggregation features introduced in Power BI Desktop in the previous month is now supported in the Power BI service. We can finally publish the models using these features, which are still in preview. Watch the videos featuring Christian Wade for more details. Read more »
• Deep dive in the organizational custom visuals
The organizational custom visuals are an important tool to safely deliver and automatically update custom visuals in existing Power BI reports within an organization. This article explains how it works in detail. Watch out the comments to the article, too. Read more »
• Testing Power BI premium features with Power BI Embedded
Testing Power BI Premium features can be hard without a yearly contract. Well, not really. Chris Webb explains how to enable Premium features for testing purposes leveraging the Power BI Embedded services, which are billed by time consumed and do not require a yearly commitment. Read more »



Variables DAX

This article describes a DAX feature introduced in 2015 that has been a game changer for the language: variables! Read more »