Non-Contiguous Date Ranges

d3struckt

New Member
Joined
Jan 16, 2012
Messages
15
What is the temporary workaround to use time intelligence functions for non-contiguous date ranges?

For example, I'm having the same error that this user is having. For example,
my new measure created is:

=calculate(sum(TE_INTL[Entry Approved Amount]),dateadd(Calendar[Date],-1,month))

However, my datetime table has data in a non-contiguous date range. What would be the work around formula and where would I input it?

http://cwebbbi.wordpress.com/2010/0...works-with-contiguous-date-selections’-error/

Rob Collie mentions a temporary solution to check if a particular date is selected, what is the solution?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

ruve1k

Board Regular
Joined
Aug 31, 2008
Messages
171
Is the issue just with your Date table? If so, then just change your Date table to have a contiguous range of dates.

Or do you mean that you are selecting non-contiguous date ranges in your PT like in Chris's example?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,743
Messages
5,524,569
Members
409,587
Latest member
ChrisF1980

This Week's Hot Topics

Top