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   (RSS)
Showing page 18 of 18 (175 total posts)
  • 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
  • The best analogy for PowerPivot so far

    I just read what I think is the best analogy for PowerPivot so far – these are the words of Amir Netz in a discussion: A good analogy is the relationship between mainsteam media (newspapers and TV) and internet blogs. In the old days (7 years back...), all of the information was provided exclusively by the mainstream media. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 21, 2009
  • Many-to-Many relationships in PowerPivot

    UPDATE: This blog post is still good for learning DAX principles, but a better description of many-to-many patterns is available on The Many-to-Many Revolution whitepaper that is available here: - please download it and use the pattern described there to write faster DAX formulas! PowerPivot doesn’t ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 7, 2009
  • 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
  • Who will be the Gemini users?

    In these days, I’m starting to use Gemini and I’m discussing about it in dedicated CTP newsgroups. I recently wrote a message that I’d like to share here, but not before some considerations. First of all, like Chris said, Gemini is less than a threat to (present and future) SSAS solutions. Far less than a threat. We already had this thought when ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 22, 2009
Privacy Statement