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 » Tabular » PowerPivot   (RSS)
Showing page 2 of 4 (35 total posts)
  • Natural and Unnatural Hierarchies in #powerpivot and #tabular

    Last week I wrote an article about Natural Hierarchies in Power Pivot and Tabular where I show why it is important creating natural hierarchies for performance reasons. I’d like to spend a few words about the reasons why this is so important, so you might read the article in advance before moving forward. I had to investigate on a performance ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 4, 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
  • Training for DAX, Tabular and Power Pivot in 2014 #powerpivot #dax

    I hadn’t time in the last two months for new blog posts, but with some good reasons! I’ve been busy putting DAX Formatter online and writing some other stuffs that I will be happy to share very soon, aside from daily engagements with customers, of course. But the waiting is almost over, and in the meantime I’d like to share the schedule for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 15, 2014
  • Format your #dax code with DAX Formatter

    When you write a DAX formula that is not trivial, you end up having a complex expression that is not really readable. I think that the same problem affect in part all Excel users, but in Excel you can easily split a formula in many steps, using different cells. This is not always possible in Tabular, because moving a sub-expression in a separate ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 13, 2013
  • Difference between LASTDATE and MAX for semi-additive measures in #DAX

    I recently wrote an article on SQLBI about the semi-additive measures in DAX. I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE and MIN – I just describe the former, for the latter just replace the correspondent ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2013
  • Handling Wrong or Missing Dates in Tabular and #powerpivot #dax

    Recently I received a request from a reader related to the handling of missing or invalid dates in Tabular (but the same can be applied to Power Pivot). In the Analysis Services Tabular book, we wrote that you can insert a special row in the Date table with an ID that can be used to map all the rows in the fact table that don’t have a valid date. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 24, 2013
  • Calculating First and Second Year of Sales by Customer in #dax #powerpivot #ssas #tabular

    I recently wrote an article that describes how to calculate a measure (such a sales, but it could be anything else) considering for each customer its first 12 months, then months 13-24 and so on. In practice, for every customer you have a different range of dates to consider, that starts on the date of its first order. In the past I implemented ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 9, 2013
  • Time Intelligence Video Tutorial on Project Botticelli #dax #powerpivot #ssas

    Alberto Ferrari recently recorded a free short video introduction about what is time intelligence. When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are specific functions grouped in a “Time Intelligence” section in the on-line documentation, but it’s ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 5, 2013
  • 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
  • Performance Tuning of #tabular models in Analysis Services 2012 #ssas

    In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about what is really used and required today in the real world. I think it is a good news that ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement