DRAG DROP
You need to create a measure named YTDPreviousSales that will be used in a table visualization. YTDPreviousSales must show the year-to-date (YTD) sales of the previous year for the same month. A sample of the desired data is shown in the following table.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
YTDPreviousSales = TOTALYTD( SUM(FactInternetSales[SalesAmount]), DATEADD(DimDate[Date],-12,MONTH) )
With calculate, you get the value for the same month, not the accumulate value since January to the current month.