I had a question by Brad at my Introduction to time intelligent functions in PowerPivot Screencast. He wanted to know if we can use the PowerPivot Time intelligent functions when we have a fiscal year that starts at Jul-Jun in combination with YTD.
The answer to that is: yes we can :). The DATESYTD function has an optional argument year end date. So you can add the end of the year at the parameter. This will look like:
This function will get the sum of nroforders of the entire year until the current month starting at 06-01 of a year, remember the All date that we need to use in CTP3.
This will result in the following pivottable, as I have no data of 2007 in my dataset PowerPivot will starts at 1/1/2008 (first date available) but you see the year starts again in July:
There are a number of other functions you can use this parameter, like nextyear and TotalYtd.