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: