Tutorial: Sales analysis, part 5 - Time Intelligence functions

Kashflow logo
Share this content

In an earlier part of our series looking at new tools for working with accounting data in Excel 2010 and 2013, we looked at some of the DAX functions available when using the Power Pivot add-in  that relate to dates and time.

We also mentioned the need to work with a special table containing all the possible dates. This time, we'll consider some...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About Simon Hurst

Simon Hurst

Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.

 

Replies

Please login or register to join the discussion.

avatar
13th Dec 2013 23:17

DAX time intelligence functions

Simon,

A very nice presentation of a subject that can be confusing. Do these functions assume a standard calendar year, Jan 1 to Dec 31?

Thanks (0)
14th Dec 2013 20:50

Thanks for your comment - much appreciated. Thanks also for the prompt about non 31 December year ends. Many of the time intelligence functions that work with years have an optional parameter to specify the year end date if different from 31/12. For example, you can use TOTALYTD() with a 30 June year end:

TOTALYTD(SUM('Order Details'[ExtendedPrice]),dimDates[Date],"30/06")

Thanks (0)