One way to do this is to create a measure for each time period:
Sales Week to Date =
IIF((DATETRUNC('week', [Order Date]) == DATETRUNC('week', #2013-04-09#)) AND
([Order Date] <= #2013-04-09#), [Sales], NULL)
Sales Month to Date = ...
(Replace #2013-04-09# with TODAY() or an parameter-based option. I often create a calculated field Today = IIF([Use Custom Date], [Custom Date], TODAY()), where Use custom date and Custom Date are both user-specified parameters.)
Also, your formula will be a little different you're using FY and a date table.
Then you can add these Measure Names / Measure Values to the Columns shelf.
Note that these measures will be calculated across the entire data set. If you have 10 years of data, consider adding a date filter so that only the relevant rows are included in the worksheet. If you're only looking at YTD max, then add a date filter that includes all dates within the last year.
DateBins.twbx 1.4 MB