How calculate First Date in calculated Member?

Question

I need to have first filtered date in mdx that doesn't filter by date dimension that used in report rows.

I need that keep date filter but by pass dates that came in rows.

score 1 · Answer 1 · answered Mar 02 '19 at 22:11

using MDX query you can use FirstChild property to get the first value of dimention members, assuming that the date dimension is called DimDate and the Date member is Date:

SELECT {DimDate.Date.[All].FirstChild} ON 1,
{ ... } ON 0
FROM [myCudbe]

Also you can use MIN() function to retrieve the minimum date value, the link above (official documentation) contains a good example.

Helpful links

How calculate First Date in calculated Member?

1 Answers1