Dates between dimensions and complete Dates

Join the date dimension with both the dates. And then use userelation to choose one. When you using the close date. Add filter to calculate formula to have not(isblank(cloase_date)) filter 

Hi Anonymous ,

How about creating a bridge table to store expand date based on its id? It will help to mapping your records so that you can use bridge table date field to filter on date range based on two date fields and correspond records.

Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,

Xiaoxin Sheng