Topic: DAX

        Page 36 of 375 posts
blog post –

PowerPivot FILTER condition optimizations

In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to give me some info about  Read more

blog post –

Stock Analysis and Moving Average with PowerPivot

One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement  Read more

blog post –

Working days calculation with PowerPivot

Whenever you have to calculate the distance between two dates, you can simply subtract two dates and DAX in PowerPivot will give you the answer. However, in case you want to calculate the difference in terms of working days you have to instruct your data  Read more

blog post –

Inside DAX Time Intelligence functions

Jeffrey Wang wrote a new post about DAX Time Intelligence functions. This is an “under the cover” description that explains the rationale behind these functions, which need to be used following particular guidelines (described at the beginning of the  Read more

blog post –

Ranking with PowerPivot – a different approach

Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot . If you know DAX or you read our book , you will find that a DAX expression can solve the issue. However, such a formula is more complex  Read more

blog post –

PowerPivot Course European Roadshow – first stop London #ppws

After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US – please  Read more

blog post –

PowerPivot Sessions from TechEd OnLine

If you have not been at Microsoft Business Intelligence Conference this year, which was co-located with TechEd 2010, you probably missed the sessions I and Alberto made there. Well, now you can watch them online on Microsoft TechEd Online site: DAX Patterns  Read more

blog post –

The Microsoft BI Roadmap: BISM, UDM and Beyond

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

blog post –

Many-to-many relationships in PowerPivot – more samples!

Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting  Read more