Ok, that worked. I now have all the values spread out across the calendar.

How do I create a calculated member that shows the value for the first day in a...

They are. The problem isn't the selection of the month, quarter or year belonging to the startdate OR enddate.

Example: a value has a startdate 1/1/2011 and an enddate of 1/1/2012.

With...

Ok, let's try another approach...

I have a fact table called [fact_component_premium]. It holds an premium amount [value], a [start_date_key] and an [end_date_key]. I also have a [dim_date] dimension with [date_key],...