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 » Excel 2013 » DAX   (RSS)
  • DIVIDE vs division operator in #dax

    Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced by following Cumulative Updates…). The idea that instead of writing: IF ( Sales[Quantity] ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2014
  • Calculate New, Returning, Lost, and Recovered Customers in #dax

    Calculating the number of new and returning customers is a recurring question. I would say this is a “classical” Business Intelligence problem, very common in marketing department. I worked on these problems with many customers, with small and large datasets, and I wrote a DAX Pattern “New and Returning Customers” showing how to calculate: New ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 26, 2014
  • Using Added Columns in #DAX Queries

    I had an issue in a query that reminded me a few details naming columns created by ADDCOLUMNS. When you specify a simple name in ADDCOLUMNS, you can use it later, for example in a SUMMARIZE or in a FILTER expression, such as in the following example (see the Value column): EVALUATE CALCULATETABLE (     ADDCOLUMNS ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 21, 2014
  • Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular

    I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that in certain business is huge and expensive, especially if you have to load it in memory. I also ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 27, 2013
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement