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

  • Question

  • 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]


    Friday, March 29, 2013 6:30 PM

All replies

  • 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.


    http://dailyitsolutions.blogspot.com/



    • Edited by Umair.Khan Tuesday, April 2, 2013 3:24 PM
    Tuesday, April 2, 2013 3:22 PM