Filter using custom date options

Hi Dale,

Thanks again for taking the time to look at this for me again.  Whilst your solution works great in terms of a new measure, it is not quite what I require.  I want the choices taken in my custom date slicer to apply to all records in my entire dashboard, not just a summing up values in new measure.  So if I select 'Yesterday', all charts, tables etc will filter accordingly, if I select This Month, again all charts, tables change again.  I realise I can use a Relative Date Slicer on my Date field, but I simply want something less cluttered.  

I don't know if this can be achieved by writing some custom code that simply relates to the my Date field, eg If DateOptions'[Category]= "Today", then filter to all records to where SalesDate = TODAY())

or

if I need to create dedicated columns in my date control table, such as Today, This Week, This Month etc and then write custom code which says If DateOptions'[Category] = "Today" then filter on column 'Today' where value = Y or If Category = "This Week" then filter on column 'This Week' where value = Y.

Thanks again

Mark