THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DAX   (RSS)
Showing page 1 of 14 (136 total posts)
  • Fix performance issue of pivot tables with Tabular models

    If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012 SP2 Cumulative Update 8. Microsoft discussed some of these improvements in this blog post: ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 22, 2015
  • Don’t ignore the Context Transition in #dax

    Almost 3 years ago I wrote an article with the rules for DAX code formatting. If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular importance for performance, too: Never use table names for measures Always use table names ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 22, 2015
  • Back to the basic: #dax primers for new #powerbi users

    The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last weeks we published two articles describing important basic concepts and clarifying the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 7, 2015
  • Power BI Desktop & Excel

    The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit Queries dialogIn case you didn't try it before, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2015
  • DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi

    If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016. There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the second group). DAX Formatter also supports the variable syntax available in the new DAX. These ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 18, 2015
  • The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi

    I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are not intuitive to understand. A function that seems ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2015
  • The new Power BI Desktop is here #powerbi #dax

    After months of public preview, Microsoft today is releasing the Power BI service to general availability. The preview was really a beta that evolved in these months, and I personally liked the approach that MS developers have now. I did not read the “it’s by design” answer to the many comments and suggestions provided in support forums and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2015
  • DAX Studio 2.2 released - tracing support for #powerpivot and much else! #dax

    Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release:Tracing (query plans and server timings) available for Power PivotBasic implementation of IntellisenseConnect to Multidimensional SSAS serversSupport for multiple Power BI Desginer instancesHighlight unnatural hierarchies (read here why this is so important for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 24, 2015
  • New features in DAX Editor #dax #tabular #ssas

    In the last few weeks I and Teo Lachev took the ownership of DAX Editor code. It is an add-in for Visual Studio that allows you to edit DAX measures in a text editor instead of using the Measure grid. It also provides other features (such as editing measures of an online Tabular database and performing a few queries). The user interface is not ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 7, 2015
  • DAX Studio 2.1 helps you optimizing #dax queries for #powerpivot #powerbi #ssas #tabular

    After the initial release of DAX Studio 2.0, in December 2014, I started working on a few features to analyze performance of DAX queries. Darren Gosbell implemented many other features, and Daniele Perilli helped us with the graphics of the UI. We certainly can do more, but I think that the current feature set of the new release is good enough to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 17, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement