Power Pivot Date Table
Trying to round out my posts of Fundamentals here - so when I ask the crazy kids on the forum "Are you building this against a Calendar table?" - I have somewhere to point them for reference. If you are seasoned. probably not a ton of excitement for you here Smile Power Pivot has a lot of really cool Time Intelligence functions. none of which have much to do with Time :) They all have to do with Dates. If you look at any of the functions in the list (say DATESYTD), the functions take some weird parameter about