date + filter + mean + median
I have 2 measures no of loans and closing balance and around 7 dimensions
the dimensions of interest are closedate which is defined as a time dimension and deal
now i need to calculate mean and median for my measures for specific deals which closed during a
within a given date range
the mdx query that i am using is
with member measures.meancal as
mean(filter([deal]members,cdate([time].closedate.currentmember.name)>=cdate(startdate) and
cdate([time].closedate.currentmember.name)<=cdate(enddate) ),[measures].no of loans )
select measures.meancal on 0
from cube
but this throws a type mismatch error ...and out of present range error , have checked the data
the deals are there.
is there any other way to do it.
i need to calculate mean and median values for my measures for deals that closed during a specified date range.
