Using Time intelligent PowerPivot functions with fiscal year
User Rating: / 0
PoorBest 
Written by Kasper de Jonge   
Tuesday, 09 February 2010 22:24

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:

Read more...

 

  Tags: excel, dax, time
 

Varigence Vivid