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   (RSS)
Showing page 16 of 17 (161 total posts)
  • Rounding functions in DAX

    Today I prepared a table of the many rounding functions available in DAX (yes, it’s part of the book we’re writing), so that I have a complete schema of the better function to use, depending on the round operation I need to do. Here is the list of functions used and then the results shown for a relevant set of values. FLOOR = FLOOR( Tests[Value], ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 25, 2010
  • TechEd NorthAmerica 2010 (and MS BI Conference 2010) Sessions

    I just read the Dave Wickert post about his sessions about PowerPivot from Microsoft at TechEd 2010 in New Orleans (June 7-10, 2010) and there are at least two things I’d like to add. First of all, there is also another conference! In fact, this time the Microsoft Business Intelligence Conference 2010 is co-located with TechEd 2010 and all the BI ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 6, 2010
  • Notepad++ used as DAX editor

    If you use PowerPivot and write some DAX formula, don't miss this post on PowerPivotPro blog - if you want to get an external editor for your DAX formula, you can use Notepad++ for free - and adding the customization described in this post by Colin Banfield, you will get function auto-complete and tooltips.
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 7, 2010
  • ALL, ALLEXCEPT and VALUES in DAX

    When you use CALCULATE in DAX you are creating a new filter context for the calculation, based on the existing one. There are a few functions that are used to clear or preserve a column filter. These functions are: ALL – it can be used with one or more columns from a table, or with the name of a table. It returns all the values from the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 5, 2010
  • How to relate tables in DAX without using relationships

    PowerPivot supports only one type of relationship between two tables, which is the one-to-many relationship. You can define that a column in a table (the “many” side) corresponds to a lookup table through a column which is an identity column there (the “one” side). DAX provides support to follow this relationship through functions such as RELATED ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 9, 2010
  • Avoiding calculated column in DAX

    A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example: You want to make part of the calculation depending on the selection in the PivotTable (i.e. selecting a scenario for a simulation) You want to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 5, 2010
  • Memory Considerations about PowerPivot for Excel

    PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with a 32 bit of Excel, there are particular considerations about the use of the memory. When an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 25, 2010
  • ABC Analysis in PowerPivot

    The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example, we wanted to define an ABC class of Products for internet sales transactions of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 18, 2010
  • How CALCULATE works in DAX

    The CALCULATE function in DAX is the magic key for many calculations we can do in DAX. However, it is not pretty intuitive how it works and I spent a lot of time trying to understand how it can be used. First of all, this is the syntax. CALCULATE( <expression>, <filter1>, <filter2>… ) The expression that we put in the first ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 3, 2010
  • Distinct Count Measure in PowerPivot using DAX

    UPDATE: PowerPivot for Excel 2010 in SQL Server 2012 and Excel 2013 support the DISTINCTCOUNT aggregation in DAX. This blog post is relevant only if you use PowerPivot for Excel 2010 in SQL Server 2008 R2. A PivotTable based on PowerPivot data doesn’t offer a native Distinct Count aggregation. To calculate it, you need to create a calculated ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 26, 2009
Privacy Statement