Hi Folks,

Just in case anyone finds this handy ::

MDX to find last incomplete week element, then average out measuresI
got data for, and provide an estimate

IIF(
CINT(SUM([Dim Date].[YWD].currentMember, [Measures].[Registrations
Qty])) > 0 AND
CINT(SUM([Dim Date].[YWD].currentMember.lead(1),
[Measures].[Registrations Qty] )) < 1,
CINT(

(SUM([Dim Date].[YWD].firstSibling : [Dim Date Vw].[YWD].lastSibling,
[Measures].[Registrations Qty]) / COUNT([Dim Date
Vw].[YWD].firstSibling : [Dim Date ].[YWD].currentMember) )
* 7

)

, 0)

------

YWD being a Year, Week, Day heirarchy

Bests,

om