Passing user input date to where clause filter to the resultset

[AnalyticsWorld]

Dear all,

I would like to get your thoughts on the below scenario.

I have a table with a reporting date as a column and associated other dimensions and measures fields.

I would like to have the user input  a start date  filter (only from the list of dates from the reporting date column )   and also the end date filter ( only from the list of dates from the same reporting date column). 

So I can   aggregate measure based on start date and end date for variance analysis calculation and derived more calculation based on it (without creating a derived table, can this achieved by same table).

  In tableau i used to pass parameter directly to where SQL and reference the same to aggregate current selected date and previous selected date to derive variance metrics. ( I would like achieve the same in LOOKER not data studio)

Thanks