Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI, which can be applied to any Time Intelligence function with a <dates> argument. The key ...

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 will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...

I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when I looked at PASS agenda I found that a session about DAX foundation was missing, and this ...