ime Intelligence simply means doing BI calculations over periods of time, or over dates. For example, a common request in many reports is to show a value, such as Sales, aggregated month-by-month, from the beginning of each year—so that you know, in this case, what were the total sales, in that year, up to the given month. DAX, Data Analysis Expressions, the language of Excel 2013, Power Pivot in Excel 2010, and in SQL Server Analysis Services (2012 or newer), includes many predefined time intelligence functions, including TOTALYTD—which is exactly the function you need to use in this particular scenario.

Let Alberto Ferrari show you how to use TOTALYTD in this short video, in which he uses it to compute Total Sales on a monthly basis, resetting automatically at the beginning of each year.

Watch video