SELECT { DESCENDANTS( [Time].[1998], [Time].[Month] ) } ON COLUMNS ,        
{ [Customers].[State Province].[BC].[Vancouver] } ON ROWS       
FROM [Sales]    
Where ( Measures.Sales,[Product].[Product Family].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Good] )   


Tail(Filter( [Time].[Month].Members, NOT IsEmpty(Time.CurrentMember)),1).Item(0)


IIF(IsEmpty(Measures.Sales), (Time.PrevMember,Measures.Sales), Measures.Sales)


IIF(IsEmpty(Measures.Sales), Time.PrevMember, Measures.Sales)


IIF(Time.CurrentMember.Level IS Time.Year, Time.LastChild.LastChild,
  IIF(Time.CurrentMember.Level IS Time.Quarter, Time.LastChild,
    IIF(IsEmpty((Time.CurrentMember, Measures.Sales)), Time.PrevMember, Measures.Sales)))

IIf(IsEmpty((Descendants(Time.CurrentMember, Month).Item(Descendants(Time.CurrentMember, Month).Count-1),Measures.Sales)),
(Descendants(Time.CurrentMember, Month).Item(Descendants(Time.CurrentMember, Month).Count-1).PrevMember),
(Descendants(Time.CurrentMember, Month).Item(Descendants(Time.CurrentMember, Month).Count-1),Measures.Sales))


Count(Product.[Product Name].MEMBERS)



Count(Product.[Product Name].MEMBERS, EXCLUDEEMPTY)


Count(Product.[Product Name].MEMBERS  * {Measures.Sales}, EXCLUDEEMPTY)


IIF( IsLeaf(Account.CurrentMember), Account.CurrentMember, Account.CurrentMember.DataMember )


IIF( IsLeaf(Account.CurrentMember), CalculationPassValue(Account.CurrentMember, -1, RELATIVE), Account.CurrentMember.DataMember )