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 » PowePivot   (RSS)
Showing page 2 of 2 (18 total posts)
  • Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

    If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows considered in the group that the SUMMARIZE uses ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 4, 2012
  • New videos available #dax #ssas #powerpivot

    The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available: DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other languages DAX: Calculated Columns vs. Measures shows the difference between calculated ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2012
  • DAX Studio 1.0 beta available #dax #tabular #powerpivot

    Are you waiting for a usable and interactive DAX editor? Are you tired of using the MDX editor provided by SSMS as a temporary solution to write and execute a DAX query? The wait is over! DAX Studio is a free Excel add-in that enables you to write a DAX query in a small dialog box that offer a productive environment, with a tabular object browser ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 30, 2012
  • String Comparison in #DAX

    In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about string comparison in DAX. During my exploration of LIKE replacement functions in DAX, I have ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 30, 2011
  • #BISM, Measures and a new blog from a #ssas development team member

    In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface of PowerPivot, but in reality the “real engine” doesn’t know the difference between ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 16, 2011
  • Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

    During TechEd 2011, Microsoft announced an important update to its BI roadmap. The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit 2010 the announcement regarding the next version of SQL Server, codenamed ''Denali'', ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 18, 2011
  • PowerPivot Course European Roadshow – first stop London #ppws

    After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US – please write me in case you are interested either as an individual or as a training company: we are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 5, 2011
  • PowerPivot Sessions from TechEd OnLine

    If you have not been at Microsoft Business Intelligence Conference this year, which was co-located with TechEd 2010, you probably missed the sessions I and Alberto made there. Well, now you can watch them online on Microsoft TechEd Online site: DAX Patterns in PowerPivot – by Marco Russo This is a very basic introduction to DAX ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 16, 2010
Privacy Statement