Hi @pdaly
As you can see in your screenshot, the same fix version can have a different start date and release date in different projects.
Therefore, there should be a question of what is the correct result on the version level in such report (which project to pick from).
Assuming you would like to cover all the issues from all projects on the Fix version level (in your report) you could try the following code (earliest version start date)
CASE WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND
[Fix Version].CurrentHierarchyMember.Level.name = "Name"
THEN
TimestampToDate(
Min(
Filter(
Childrenset([Fix Version.By name].CurrentHierarchyMember),
[Measures].[Issues created]>0
),
DateToTimestamp([Measures].[Version start date])
))
WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND [Fix Version].CurrentHierarchyMember.Level.name = "Project"
THEN
DateParse([Measures].[Version start date])
END
It would return the earliest version start date. You can use this new calculated measure instead of “Version start date” in your report.
And then similarly you could use Max function in that formula to return the last date from Version release date
Martins / eazyBI support
