Ok why should i want to load an entire time table in PowerPivot ?
Ok remember the Time intelligent function golden rules ? One of the key items there is :
- Always create a separate Time table.
And why is that you think? Well i got a question about someone doing a previous year but got only values until the current month he has data, like this: