Using Time intelligent PowerPivot functions with fiscal year

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:

, DATESYTD(‘Date'[Date],”06-01″)

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.