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 (15 total posts)
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement