Using Time intelligent PowerPivot functions with fiscal year

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

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:



Tags: dax, excel, time


2007-2015 VidasSoft Systems Inc.