MDX - Count Number of Minutes In A Selected Period Up To Current Day -
09-17-2003
, 12:37 PM
I have created a calculated measure that counts the number of minutes
in a selected date period (ie. Year, Month, Week, Day) based on what
is selected from the date dimension. It works fine for periods that
are in the past, but what I really need is if a period is not complete
to only return the minutes up to the current day. (ie. Today is
September 17. If I am reporting on the month of September, I want
total minutes through yesterday, not total minutes for the entire
month.)
This is the calculated measure as it currently exists (1440 - 60
minutes * 24 hours):
count(descendants( fiscal_calendar.currentmember,[day])) * 1440
Any help would be appreciated...
Ben |