In many situations besides the normal calendar we are faced with the fiscal calendar , which as we know the year start date does not match with that of the classical calendar.
Use the measurements in PowerPivot with the fiscal calendar becomes complex , as they are based on the classical calendar. Fortunately, there are a series of time intelligence functions that take this particularity of this .
A good solution to this problem can be:
=CALCULATE(sum(‘Tablix1′[nroforders]);DATESYTD(‘Date'[Date],”06-01″);ALL(‘Date’))
DATESYTD is one of the functions of time intelligence that allows you to give a different starting date . As can be seen from the formula is very simple to use , you have to enter the reference date column on which to do the calculation and the date at which we want to stop the year ( in this case to June 1 ) .
So for all the other measures we can safely use this parameter to wire them correctly.