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]