Time Intelligence current Week RRS feed

  • Question

  • Hi I am new to performance point and I'm having difficulty to understand what it going on with the the time intelligence

    if I create  a date range and in the formulas I put the following





    I get the following results

    day = [Date Primary Date].[Year - Quarter - Week - Date].[Date].&[20140607]

    day-1 = [Date Primary Date].[Year - Quarter - Week - Date].[Date].&[20140606]

    year = [Date Primary Date].[Year - Quarter - Week - Date].[Year].&[20140101]

    week = [Date Primary Date].[Year - Quarter - Week - Date].[Week Name].&[2014-03-09]

    I understand them all apart from the week which doesn't give me the current week which should be 2014-05-31

    Why is this happening?

    Saturday, June 7, 2014 8:03 PM


  • I went back to the setting of the time intelligence and reconfigured the date members in the data source
    • Marked as answer by aivoryuk Wednesday, July 2, 2014 3:01 PM
    Wednesday, July 2, 2014 3:01 PM