PowerPivot relationships RRS feed

  • Pergunta

  • 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

    quinta-feira, 1 de março de 2012 22:37

Todas as Respostas

  • Diogo, good morning,

    their source data originates from a cube in ssas?


    Eduardo Gomes - - Twitter: @edugp_sp

    sexta-feira, 2 de março de 2012 12:35
  • Diogo,

    The value of this product coupled with its moving?

    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário |]

    terça-feira, 6 de março de 2012 13:10