PowerPivot relationships RRS feed

  • Question

  • I have a problem understanding how the PowerPivot relationships work.

    I have 2 tables. The first one consists of a calendar. Each date appears once and each date has a value, which I call daily reference.

    The second table consists of sales, that is, a date, a product and a value.

    When I create a relationship between the dates and create a pivot table, I expect this relationship to exist for both the daily reference and for the product value. But that is not what happens. As you can see in the image attatched, the relationship just seems to work for the product value, but not for the daily reference. Why does it happen?


    Diogo Holanda

    Friday, March 2, 2012 1:22 PM


All replies