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 (163 total posts)
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • Many-to-many relationships in PowerPivot – more samples!

    Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting also for another reason: it can open up your mind about why Vertipaq (the engine of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 20, 2010
  • Inside DAX session at PASS

    I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when I looked at PASS agenda I found that a session about DAX foundation was missing, and this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 15, 2010
  • Define groups of values using PowerPivot

    Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires to change the cube structure on the server, something that an end user is not allowed to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 14, 2010
  • PowerPivot book RTM! And some DAX thoughts…

    Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS. A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning and we hope it will be a good book for both advanced Excel users (who are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 17, 2010
  • 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
  • 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
Privacy Statement