Chris raised a question about SoftArtisan acquisition, and we are often wondering about ProClarity acquisition and Dundas licensing (Dundas had a Pivot Table for the web that today is a big lack in Reporting Services and is available only through Excel Services in SharePoint).

Anyway, the point is: what is the long term strategy for BI Client in Microsoft? This is an important question for all those companies that don’t have (and/or don’t plane to use) SharePoint. Or that are going to use SharePoint in a hosted environment for their collaboration purposes (Microsoft sells this service!) but still have data on their servers. And they want to analyze (and internally publish) these data. Today, I really don’t have an answer and this is not a good situation for a consultant like me.

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

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more