Year to Date

Year-to-date (YTD) is a period starting from the beginning of the current year and continuing up to the present date.You want to calculate the YTD sales and compare this with the figure from the same period last year. Specifically, you will create the following measures YTDSales: calculates the YTDsales. Format this measure asCurrency.(Hint: Check out theTOTALYTDfunction).

LY YTD Sales: calculates last year YTD sales.Format this measure asCurrency.(Hint: You might find theCALCULATEandSAMEPERIODLASTYEARfunction useful).

YTD Sales Var: calculates sales variance between this year and last year YTD sales.Format this measure asCurrency. (Hint: This is simply the difference betweenYTDSalesandLY YTD Sales).

YTD Sales Var %: calculates sales variance between this year and last year YTD sales in percentage.Format this measure asPercentage. (Hint: This is simply the percentage ofYTDSales VarfromLY YTD Sales. You might find theDIVIDEfunction useful).