THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DAX » Excel » PowerPivot   (RSS)
  • DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

    I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog, this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this new release, but unfortunately it will require some weeks because I'm traveling a lot in these ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 4, 2013
  • LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular

    During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence module, because its typical use case is on a date column. However, you can use these functions ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 19, 2013
  • 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 calculations that might be useful when you want to implement some stock analysis using ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 27, 2011
  • 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 will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • How CALCULATE works in DAX

    The CALCULATE function in DAX is the magic key for many calculations we can do in DAX. However, it is not pretty intuitive how it works and I spent a lot of time trying to understand how it can be used. First of all, this is the syntax. CALCULATE( <expression>, <filter1>, <filter2>… ) The expression that we put in the first ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 3, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement