• 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

Many-to-Many relationships in PowerPivot

Dec 7, 2009
DAX   Power Pivot  

Marco Russo

Profile   Blog

Blog Archives
  • 2026 (1)
  • 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
Mar 3-5, 2026
Amsterdam
Register
The best analogy for PowerPivot so far
SSIS remote execution and SqlBulkCopy performance analysis
Jan 26, 2026

Show transaction details on the matrix visual in Power BI

This article shows how to create a DAX measure that displays information from multiple columns in a business entity or transaction, into a single column of a matrix.  Read more

Jan 9, 2026

Analyzing the performance of limited and regular relationships

This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.  Read more

Dec 15, 2025

Measuring the impact of promotions on sales in Power BI

This article describes the data model and DAX measures to analyze the effectiveness of campaigns, by separating attributed sales (directly linked to a campaign) from influenced sales (all sales of products participating in campaigns, regardless of attribution).  Read more

Dec 1, 2025

Using RANK instead of RANKX in DAX

Should you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. RANK Returns the rank for the current context within the specified…  Read more

41:15
Jan 27, 2026

Show transaction details on matrix visual in Power BI

Watch now
04:21
Jan 20, 2026

Optimizing supermarket product placement with Synoptic Panel in Power BI

Watch now
18:19
Jan 13, 2026

Performance of limited and regular relationships in Power BI

Watch now
09:15
Dec 30, 2025

What happened in DAX in 2025

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

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

What is next

  • Mastering DAX – Mar 3
    , Amsterdam
  • Mastering DAX – Mar 30
    , Houston
  • Mastering DAX – Apr 8
    , New York City
  • Mastering DAX – May 5
    , Copenhagen
  • Mastering DAX – May 27
    , Baltimore
  • Mastering DAX – Jun 10
    , Zürich
  • Mastering DAX – Jun 15
    , Berlin
YouTube Twitter 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