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
day
day-1
year
week
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?