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 » PowerPivot   (RSS)
Showing page 2 of 6 (58 total posts)
  • 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
  • Understanding #DAX Query Plans for #powerpivot and #tabular

    Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we'll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of many months of study - we know that we just scratched the surface of this topic, also because we ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 22, 2013
  • Group Sales by Age of Customers #dax #powerpivot #tabular

    I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this specific case is useful also to recycle the formula that gets the exact age of the customer for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 6, 2013
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement