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


Understanding numeric type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more »



Learning DAX and data modeling in 2019

We published many dates of courses in 2019. In the next two weeks we will publish additional dates in Europe (May-July), North America (May-June), and Australia (July-August).

Don't miss the early bird offer for the first Mastering DAX courses of the year:

Seattle, WA, US – Feb 6-8
Atlanta, GA, US – Feb 11-13
Amsterdam, NL – Feb 19-21
London, UK – Mar 13-15
Vancouver, BC, CA – Mar 13-15



Latest news on Power BI

• Power BI Dataflows FAQ
Matthew Roche created a page with the frequently asked questions (FAQ) about Power BI Dataflows. This new feature is still in preview and will have a big impact in solutions based on Power BI, but it is also frequently confused or misunderstood. This page helps in clarifying many doubts, and if you need more details the Matthew's blog has many articles describing both the architecture and the implementation of Power BI dataflows in more details. Read more »
• Implementing basic query folding on a web service in Power Query/M and Power BI
If you import data from a web service that provides advanced filtering capabilities, Chris Webb describes how to implement query folding in the connection. Advanced content to improve performance in otherwise slow scenarios. Read more »
• Learn DAX at SqlBits 2019
Alberto Ferrari and Marco Russo will be teaching DAX at SqlBits 2019 in Manchester, UK. If you are new to DAX you can attend the From 0 to DAX training day (by Alberto) on Feb. 27. If you are already confident with DAX, you can go straight to the Advanced DAX day (by Marco) on Feb. 28.



Semi-Additive Measures in DAX

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