Member: Revenue Avg Amount FYTD
CREATE MEMBER CURRENTCUBE.[MEASURES].[Revenue Avg Amount FYTD]
AS NULL,
FORMAT_STRING = "Currency",
NON_EMPTY_BEHAVIOR = {[MEASURES].[Revenue Amount]},
VISIBLE = 1 , DISPLAY_FOLDER = 'Fiscal Year To Date' , ASSOCIATED_MEASURE_GROUP = 'Revenue';
(
[Date].[Fiscal Year].[Fiscal Year].MEMBERS
,[Date].[Fiscal Date].MEMBERS
,[MEASURES].[Revenue Avg Amount FYTD]
) =
Avg
(
PeriodsToDate
(
[Date].[Fiscal Date].[Fiscal Year]
,[Date].[Fiscal Date].CurrentMember
)
,[MEASURES].[Revenue Avg Amount]
);
// CYTD