• SQLBI

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

Many-to-Many relationships in PowerPivot

Dec 7, 2009
DAX   Power Pivot  

Marco Russo

Profile   Blog

Blog Archives
  • 2026 (7)
  • 2025 (8)
  • 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
The best analogy for PowerPivot so far
SSIS remote execution and SqlBulkCopy performance analysis
Sep 22, 2026

Where we stand on AI and DAX in 2026

The time has come: in 2026, using AI to write DAX has started to be effective. Let me recap what has changed between 2023 and 2026, and what we are doing with our three new courses to best assist you…  Read more

Sep 21, 2026

The hidden complexity of a daily average in DAX

A simple daily average masks a level of complexity that may not be immediately apparent. In this article, we use AI to create a daily average, and then to analyze several edge-case scenarios to build a sound calculation.  Read more

Sep 7, 2026

Writing DAX at the correct granularity

A DAX calculation can produce convincing values at the detail level and still fail at the total. The problem is often not the total itself: the business rule was evaluated at the wrong granularity. This article introduces four grains, or…  Read more

Aug 24, 2026

Testing DAX measures by using AI

This article describes how to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure.  Read more

23:29
Sep 22, 2026

The hidden complexity of a daily average in DAX

Watch now
14:38
Sep 8, 2026

Writing DAX at the correct granularity

Watch now
07:13
Sep 2, 2026

Matrix Totals - The Whiteboard #13

Watch now
22:14
Aug 25, 2026

Testing DAX measures by using AI

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

By subscribing, you agree to our Privacy Policy. This site is protected by reCAPTCHA.
276.5K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – Oct 12
    , Warsaw
  • Mastering DAX – Oct 27
    , Lugano
  • Mastering DAX – Nov 9
    , Atlanta
  • Mastering DAX – Nov 24
    , London
  • Mastering DAX – Dec 1
    , Amsterdam
YouTube X LinkedIn Facebook Github RSS Feed
Marco Russo Alberto Ferrari Daniele Perilli
2004-2026 © 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 Patterns
  • DAX Lib
  • DAX.do
  • DAX Formatter
  • DAX Optimizer
  • Bravo for Power BI