Following fact table
If the user selects a date in the time dimension I want to build the sum of Amount where the selected date is between StartDate and EndDate.
SELECT SUM(Amount) WHERE <date> between StartDate and EndDate
Is it possible to create a calculated measure like this.
View Complete Post