I am trying to pull a parallel period to date, and it works when using it for a date ending, but how do you get the data for a week, month or year when it is only partial? For example, I use CUBEMEMBER("datasource","parallelperiod([Time Periods].[Descriptive Fiscal Periods].[Fiscal year],1,[Time Periods].[Descriptive Fiscal Periods].[Fiscal Week] and then point to another cell that holds the date for the date to use. Works great except if I want to pull data on say a Thursday (or would be yesterday), the current week will only pull five days of data, while the parallel period by week for last year will pull seven days. Is there a way to adjust so it will pull to the day?