Hello I’m new to MDX and EazyBI but have a problem that I have been unable to move past after reading about several functions/similar problems.
I’m trying to figure out how can use a replacement of affects version to get the stored release date.
I need the lowest affects versions release date to determine if the issue escaped or not.
The problem, my project can have multiple affects versions return on a single issue i.e. Affects version (1.00, 1.10) etc.
I got the lowest affects version by using:
cast(
ExtractString([Measures].[Issue affects versions],"^.{5}") as NUMERIC
)
The problem is I need to use the above retrieved value on the dimension:
The release date is stored like this:
[Affects Version].CurrentMember.get('Release date')
So I just want in essence to do something like this:
[Affects Version] = cast(ExtractString([Measures].[Issue affects versions],"^.{5}") as NUMERIC).CurrentMember.get('Release date')