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


Semi-additive measures in DAX

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



FREE Introduction to Data Modeling video course

SQLBI is now offering a new free video course: Introduction to Data Modeling for Power BI. This article describes which users will benefit from this learning experience the most, and how to enroll in the course.
Read more »
Free enroll now »



Upcoming DAX courses

Mastering DAX in Unites States:
Orange County, CA / Cincinnati, OH /
New York, NY / Portland, OR
Mastering DAX in Europe:
Amsterdam, NL / Helsinki, FI / Aarhus, DK
Mastering DAX in Australia:
Brisbane / Sydney / Melbourne / Perth



Latest news on BI

• Update on the New Workspace Experiences Preview
Microsoft announced that the new workspace experience for Power BI (currently in preview) will become generally available in April 2019. If you did not pay attention to the changes coming in the workspace features, you should absolutely read this article and plan accordingly. Read more »
• Slideshow mode in Windows Power BI app
The Windows Power BI app is almost unknown – but you can install a Power BI Mobile app from the Windows Store that runs on any desktop and enable a presentation mode that now can also run a slideshow. You don't need to export your reports to PowerPoint, just click on Play! Read more »
• XMLA endpoints in preview for Power BI Premium
The data models published as datasets in Power BI Premium can now be seen as Analysis Services database through XMLA endpoints, enabling access from any existing XMLA-compliant tool. DAX Studio and Reporting Services are the first two tools that can use this service, because at the moment it is read-only. Tabular Editor must wait the support of read-write features – which should be available soon. Read more »
• DAX Studio 2.8.4
Another set of bug fixes and small changes for DAX Studio that also improve the support for the XMLA endpoints and the analysis of Power BI aggregations. Download now »
• Analysis Services 2019 CTP 2.4
The new CTP version of Analysis Services 2019 introduces the many-to-many cardinality for relationships in the data model, the same feature that has been introduced in Power BI with the composite models a few months ago. There are also new settings to limit resources used by a single query. Improvement in calculation groups will appear in a future CTP. Read more »
• Intelligent Cloud Conference
Marco Russo will deliver two breakout sessions at the Intelligent Cloud Conference in Copenhagen on April 9-10, 2019: "DAX Filter Context in 1 hour" and "Aggregations in Power BI". If you are in Denmark, or you need a good reason to visit it, you can still register. Register now »