Hi Vivek,

As per my understanding you wanted a make provision to show and select two dates.

With the dates you wanted control all the functionalities of the current and other blended data sources.

If I'm right, I would prefer to create two date parameters called Start date (30-sep-18) and End Date (31-dec-22)

E.G. End Date sample parameter

With two parameters you can control all datasources in tableau workbook.

Hope this helps! Plz mark the response as helpful and answered if it solved the problem

Hi Vivek,

Can you try the calculations for above desired results

Dates Difference:

Datediff('day',[Startdate],[Enddate])

Booking Amount:

[Booking amount] / [Dates Difference]

# of nights:

[# of nights] / [Dates Difference]

# of bed nights:

[# of bed nights] / [Dates Difference]

Hi, Vivek

Is it something like this?

join your data to a calendar table using the key 1=1

create a filter and drag to filter, then select true, and right click the filter and select add to context.

Workbook attached for your reference.

Hope this helps

ZZ

Hi, Vivek

It located in your original thread

Creating a date range measure to connect other database

ZZ