In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {“year”, [Order Dace]) = DATETPUNC)"year", TODAY(J)
You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Submit