Need to be able to automatically filter visuals to show 180 days prior to selected date

[Anonymous]

I have data coming from SQL server database. How can i get my table visual to show 180 days prior to the date selected in either a slicer or another line chart I have that gets refreshed daily. I just want to be able to freely click or hit a date and it show me the data in the table visual of that same date and 180 day.

[vicky_]

 Measure = CALCULATE( //your calculation here, 
    REMOVEFILTER([Date]), // only need this if you don't have a disconnected date table

    DATEADD(SELECTEDVALUE[Date]), -180, DAY)

)