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 » Tabular » PowerPivot » DAX   (RSS)
Showing page 1 of 5 (49 total posts)
  • BLANK and Boolean functions like IF in #dax

    A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example, consider that the result of the following expression is FALSE and not BLANK: IF ( 1 = 1, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 14, 2016
  • Leverage INTERSECT to apply relationships in DAX

    If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX), you probably use the following pattern relatively often: [Filtered Measure] := CALCULATE (     <target_measure>,     FILTER (         ALL ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 26, 2016
  • GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

    If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you get unexpected results or you have performance issues. The new GROUPBY function (also available in SSAS ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 15, 2016
  • Conferences and Training in Australia Feb/Mar 2016 #dax #sqlsaturday

    In a couple of weeks, I will move to Australia for 3 weeks, visiting Melbourne and Sydney for a number of events and training. This is the list of topics in public events you can attend (with link to registration pages – remember that SQL Saturday conferences are free events, but you still have to register first!): UPDATE 2016-02-08 - added a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2016
  • Challenge your #dax skills with DAX Puzzle #powerbi #powerpivot

    Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution. You can download a sample file (in Power BI Desktop, which is freely available to anyone – ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 21, 2015
  • The Definitive Guide to DAX is now available! #dax #powerpivot #powerbi #ssas #tabular

    I am so happy to announce that The Definitive Guide to DAX is finally available! I and Alberto Ferrari spent one year writing this book, and several years collecting the knowledge necessary to do that. The complete title is The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI. You can ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 20, 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
  • 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
  • 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 >
Privacy Statement