Topic: DAX

        Page 35 of 380 posts
blog post –

#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

blog post –

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

blog post –

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

blog post –

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

blog post –

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

blog post –

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

blog post –

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

blog post –

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