Tableau previous week and month to date calculate

This seems easy, but there is a tricky part, both should be imemented without using filter pane.. It should be pure calculated fields and both must be in the single table , the value is difficult yo acheive due to null values in dimension, need skilled tableau person