Project Botticelli

What is Time Intelligence? Get Free Access Purchase this course

28 August 2013 · 5420 views

Using DAX Language for Time-based Calculations

TOTALYTD DAX Time Intelligence Function

Time Intelligence means doing calculations over periods of time or dates. Let Alberto Ferrari show you how to use TOTALYTD to compute Total Sales Year-to-Date in Excel in this free 2-min video. Log-in or get a free account to watch it!

Time 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 2016, 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, best-selling author of books on DAX, and a renowned SSAS expert, 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.

If you find this useful, however, make sure to learn about the remaining Time Intelligence functions, including the use of CALCULATE with predefined and custom filters, dealing with week numbers (including ISO weeks), or computing semi-additive measures, such as balances, including last-day, or last-non-empty aggregations—all of which Alberto explains in great detail in his 1-hour DAX: Time Intelligence video training module, part of our online Data Analysis Expressions course.

Log in or register for free to access this content.

Purchase This Course or Full Access Subscription

Single Course

$250/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Jump to a chapter

Online Courses