Forum Discussion
Why does two calendars not work in power pivot when related to different date field in one table ?
Perhaps I misunderstand something, let play with the sample. We have source data and two linked calendars
and built on them Pivot Tables as in attached file
is that like what you do?
Perhaps I misunderstand something, let play with the sample. We have source data and two linked calendars
and built on them Pivot Tables as in attached file
is that like what you do?
Thank you Sergei for breaking it down into smaller pieces - I see that the lead time field which I included as the variable between the start date and the end date was based on an average in the historic data, and hence not a whole number (as you have used in the example file), consequently the pivot table returned the header as 'blank' instead of the month and year. I will adjust the model accordingly.
Many thanks.