Home Forums Power Pivot Issue creating relationship with calendar table

This topic contains 2 replies, has 2 voices, and was last updated by  bdeuce14 2 years, 11 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #7048

    bdeuce14
    Participant
    • Started: 11
    • Replies: 14
    • Total: 25

    I have a table that contains historical data and I created a separate calendar table to write time intelligence measures against.

    Powerpivot is allowing me to create the relationship but when I drop the values into a pivot table it’s not recognizing it.

    I’m using the calendar titled [Calendar_Trending Denials] and the transaction table called [Denials_Trending]

    I’ve attached the workbook here.

    #7049

    tomallan
    Keymaster
    • Started: 0
    • Replies: 417
    • Total: 417

    Hi,

    Try creating a zip file to lessen file size (or remove some data rows). File size limit is 1,024,000 (1 MB or 1024K).

    Having not seen the data yet, let me toss out one guess: when this happens to me it can be the case that there is a one-to-one relationship between a record in the fact table and a record in the calendar table and, when making the connection, I dragged from the calendar table down to the fact table (not from fact table up to calendar).

    If my guess does not apply, looking forward to the smaller size file.

    #7051

    bdeuce14
    Participant
    • Started: 11
    • Replies: 14
    • Total: 25

    Your guess worked as designed! Thank you Tom.

Viewing 3 posts - 1 through 3 (of 3 total)

The forum ‘Power Pivot’ is closed to new topics and replies.