You may be able to solve the issue by creating a calculated field.
If [Date Field] <> dd-mm-yy then [Measure Field] end
You can do a similar calculation if you want to remove a week or months data.
Hope this helps.
If I have interpreted your requirement incorrectly please let me know