@Anu Create a column in your date table that will contain True for past dates and False for future dates and then use that column to filter dates table.
If you ever want to create a visual with Running total and hide dates after a certain date then you can first create a calculated column in your date table like this:
Date Less Than My Date ? = Dates[Date] < DATE ( 2009, 7, 5 )
[1]
After that create a visual with your date hierarchies, I generally use Matrix, and then you can create a piece of DAX like this one
[3]
And then add a new filter through the filter pane by using the column from the dates table created in the previous step, likeā¦