I am trying to calulate avg for part count by dept. I
need it to use previous time level for avg.

Example:
I have a time dimension of Year/Week/Day. I have another
dimension of Dept with 5 departments. When Showing Time
for a week I need the avg per dept for all days in that
week. When showing time for Year I need avg for all weeks
in that year.

Any ideas? It seems to me that the basic calc member
would look like:

Avg({[Customer Dept].CurrentMember},CoalesceEmpty
([Measures].[Part Count],0))

How do I apply time to this? In a where clause?

Any help would be appreciated,

Thanks, Darryl