• SQLBI

  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
  • Menu
  • Search
  • 0
  • LOGIN
  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
LinkedIn Twitter Facebook Email
Marco's blog

ABC Analysis in PowerPivot

Jan 19, 2010
DAX   Power Pivot  

Marco Russo

Profile   Blog

Blog Archives
  • 2025 (6)
  • 2024 (19)
  • 2023 (11)
  • 2022 (10)
  • 2021 (8)
  • 2020 (11)
  • 2019 (11)
  • 2018 (17)
  • 2017 (25)
  • 2016 (28)
  • 2015 (40)
  • 2014 (59)
  • 2013 (52)
  • 2012 (52)
  • 2011 (89)
  • 2010 (61)
  • 2009 (26)
  • 2008 (44)
  • 2007 (57)
  • 2006 (45)
  • 2005 (36)
  • 2004 (10)
Feed RSS
Oct 1-3, 2025
London
Register
Memory Considerations about PowerPivot for Excel
PASS Summit 2009 Evaluations
Aug 11, 2025

SUMMARIZECOLUMNS best practices

SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the best practices when using this function to avoid incorrect results. SUMMARIZECOLUMNS Create a summary table for the requested totals…  Read more

Aug 12, 2025

Sideways recursion in DAX calculation groups

This article describes the sideways recursion triggered by invoking a calculation item from another calculation item, explaining why it should be avoided to steer clear of unexpected results.  Read more

Aug 4, 2025

Understanding SUMMARIZECOLUMNS

This advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices. SUMMARIZECOLUMNS Create a summary table for the requested totals over set of groups. SUMMARIZECOLUMNS…  Read more

Jul 28, 2025

AI in Power BI: Time to pay attention

This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabric with a large language model (or LLM).  Read more

17:13
Aug 12, 2025

SUMMARIZECOLUMNS best practices

Watch now
39:08
Jul 29, 2025

AI in Power BI: Time to pay attention

Watch now
06:25
Jul 28, 2025

Why we waited so long to talk about AI

Watch now
21:43
Jul 15, 2025

ALLSELECTED best practices

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

 By subscribing you are agreeing to our Privacy Policy.
263.2K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – Oct 1
    , London
  • Mastering DAX – Oct 28
    , Lugano
  • Mastering DAX – Nov 4
    , Amsterdam
  • Mastering DAX – Nov 12
    , Chicago
  • Data Modeling for Power BI – Dec 2
    , Amsterdam
  • Mastering DAX – Dec 8
    , Austin
YouTube Twitter LinkedIn Facebook Github RSS Feed
Marco Russo Alberto Ferrari Daniele Perilli
2004-2025 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.
Privacy Policy & Cookies Terms & Conditions Contact Us
  • SQLBI
  • DAX Guide
  • DAX.do
  • DAX Optimizer
  • DAX Patterns
  • DAX Formatter
  • Bravo for Power BI