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 » PowerPivot » PivotTable   (RSS)
  • 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
  • Difference between DISTINCT and VALUES in DAX

    I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name of the table. A relationship exists between Fact[Fact] and Dim[Dim]. This relationship ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2011
  • Gemini is now PowerPivot

    The project codenamed Gemini has an official name now: PowerPivot. The complete name should be “PowerPivot for Excel 2010”, but PowerPivot is simpler. I didn’t like that name yesterday, but today it seems better. Microsoft announced this name at the Microsoft SharePoint Conference 2009 held in Las Vegas. As usual, demos are good and people are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement