PowerPivotPro's FAQ Site

When using Time intelligence functions like LASTDATE or DATESMTD it is necessary to add another argument which is ALL (TimeTable). Without this, only the selected dates are considered.

 

Example:

=CALCULATE(sum(‘FactInternetSales’[OrderQuantity]),DATESYTD(PREVIOUSYEAR(‘DimDate’[FullDateAlternateKey])),ALL(‘DimDate’))
This gives the ytd of the previous year.

You could also add separate time table which you can relate to your other tables, use a date column to create the relationship. When you do this the additional argument isn't necessary.

More on this at: http://www.powerpivotblog.nl/powerpivot-time-intelligent-functions-revisited-why-use-all-and-how-to-work-around-it

Quanto se está usando funções de tempo (Time) inteligentes como LASTDATE ou DATESMTD, no CTP3, é necessário adicionar outro argumento que é o ALL (TabelaTempo) ( ALL (TimeTable)). Isto não será necessário após o CTP3. Sem isto, apenas as datas selecionadas são consideradas.

 

Exemplo:

=CALCULATE(sum(‘FactInternetSales’[OrderQuantity]),DATESYTD(PREVIOUSYEAR(‘DimDate’[FullDateAlternateKey])),ALL(‘DimDate’))
Isto resulta no ydt do ano anterior.