As you might know, I wrote three books about LINQ with Paolo Pialorsi. He’s an expert in SharePoint development and after one year of tough writing it is finally available its Microsoft SharePoint 2010 Developer Reference book. If you want to write code  Read more

These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up! Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and Alberto Ferrari will present  Read more

Several months ago I wrote about the issue importing measures from an Analysis Services cube in PowerPivot. The short story is that, when you define the MDX query, all columns are imported as Text. Of course, this is not a good thing for the numeric measures.  Read more

Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX . I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this  Read more

A common feature request for PerformancePoint is importing a briefing book from ProClarity. As far as I know, this is not available. Today (thanks to a tweet from @denglishbi ) I discovered a product, Pyramid Analytics bioXL , which has a specific feature  Read more

Most of the readers of this blog probably have a good knowledge about MDX. But if you are new to MDX or want to improve a basic knowledge, and you’re in London or you are looking for a very good reason to visit the city, then you cannot miss the public  Read more

Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot . Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each item  Read more

The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group , Excelbi.dk and the Swedish SQL Server User Group . The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen, and this is the topic  Read more

The early bird discount for the PowerPivot Workshop in Dublin will expire today, Friday 11 March. There is also an upcoming workshop in Copenhagen (March 21-22, 2011) and a PowerPivot workshop in Zurich on April 4-5, 2011. I and Alberto are preparing  Read more

I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name  Read more