Topic: DAX
#PowerPivot Workshop in Lisbon – Portugal #ppws
Alberto anticipated me announcing our next edition of the PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The announcement has been published also on the SQLPort website in Portuguese! But remember, the workshop will be entirely in Read more
Parent-child special calculations in #BISM #Tabular #Denali
Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child Read more
First steps with #ssas #Tabular in #Denali #CTP3
The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and acronyms Read more
DAX Deep Dive at #sqlbits9
I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save the date for SQLBits! Read more
PowerPivot, basket analysis and the hidden many to many
Surfing on the web, here , I came into this intriguing question: How do we ask something like “Show me how many customers have an iPad but don’t have a book?” We are speaking about a sales analysis where the canonical entities are Customers, Products Read more
Microsoft updates its BI Roadmap – #ssas #bism #teched #powerpivot
During TechEd 2011, Microsoft announced an important update to its BI roadmap . The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit Read more
SSAS Maestro in Madrid (July 2011) and SQLPASS in Seattle (October 2011) #ssasmaestro #sqlpass
In the last months I talked mostly about PowerPivot, but Analysis Services is still growing and a very good sign of that is the number of downloads of The Many-to-Many Revolution whitepaper, who has been published almost 5 years ago and recently surpassed Read more
Recursive calculations in MDX #ssas #mdx
Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I’m doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I’m discovering that MDX Read more
The Last Ever Non Empty calculation in MDX
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
Thinking in DAX (#powerpivot and #bism)
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