This topic contains 2 replies, has 2 voices, and was last updated by 
-
Posts
-
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.
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.
Your guess worked as designed! Thank you Tom.
The forum ‘Power Pivot’ is closed to new topics and replies.