Time Intelligence formula to span from 1/1/2008-yesterday (or show last 20 years through yesterday)

need help with Time Intelligence to show a date range (this is for a KPI). My time dimension starts at 1/1/2008, so I'd like to have that hardcoded, but not necessary. I need the date range to span through yesterday (day-1), as well as have a second one that spans through the day before yesterday (day-2). I can't seem to get the syntax right. 

Sample of day-1: [Date].[Year - Quarter - Month - Date].[Date].&[2013-03-28T00:00:00]


March 29th, 2013 9:30pm

To get date range from start of time up till your desired date you can use range as:

null : Day -1

null defaults to first member giving to complete range.

Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2013 6:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics