Can i use an if statement in Time Intelligence? RRS feed

  • Question

  • I want to setup time intelligence to use Month-1 if Day=1-10th of the current month. if Day>10th of the current month, then use Month. Is this possible? I can't figure out the syntax.
    • Edited by kayluhh Wednesday, August 7, 2013 9:26 PM
    Wednesday, August 7, 2013 9:21 PM

All replies

  • Do you mean where you configure Time on the data source?  

    If not, can you provide more details where you are trying to configure this logic?

    Dan English's BI Blog

    Monday, September 2, 2013 8:31 PM
  • No, I'm talking about in PerformancePoint Services. Sorry for not being clear. When I create a time intelligence filter, instead of using Day-1 i want it to be like "if day-1=the first day of the month, then show the previous month instead, otherwise show current month"
    Monday, October 28, 2013 9:17 PM