Report Portal

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 . And the documentation is just horrible. So. what's up? What is that thing?

Read more...

Tags: design, tabular

 

2007-2015 VidasSoft Systems Inc.