Useful list of time calcs for powerpivot and soon to be tabular bi models.

http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-dax-time-intelligence-functions.aspx