Hi @martins.vanags ,
I have two issuetypes : Issuetype 1 (called Concept Deliverable) and Issuetype 2.
All issues of iyyuetype2 are linked to issue of issuetype 1 and have a Fix Version. I would like to use issuetype 1 as a summary row. That means I would like to have the information of the first fix version of the linked issues of issuetype 1. I get all fix versions of the linked issue in row one. But I would like to have only the first fix version of the linked issues.
I would like to have R20-11 in the first row only or the release date in the first date only.
I would like to have 2021-11-30 in the first row only or the release date in the first date only.
Here my code:
Planned Release:
CASE
WHEN [Measures].[Issue type]=“Concept Deliverable”
THEN
Generate(
Filter([Fix Version].[Version].Members,
[Measures].[Issues created]>0 AND
[Fix Version].CurrentHierarchyMember.Name <> “(no version)” AND
[Fix Version].CurrentHierarchyMember.Name <> “unspecified”
), [Fix Version].CurrentHierarchyMember.Name, ", "
)
ELSE [Measures].[Issue fix Versions]
END
Code for Release Date:
CASE
WHEN [Measures].[Issue type]=“Concept Deliverable”
THEN
Generate(
Filter(
[Fix Version].[Version].Members,
DateInPeriod(
[Fix Version].CurrentMember.get(‘Release date’),
[Time].CurrentHierarchyMember
)
AND
([Time].CurrentHierarchy.DefaultMember,[Measures].[Issues created]) > 0
),
[Fix Version].CurrentHierarchyMember.GetString(‘Release date’),
', ’
)
ELSE
Generate(
Filter(
[Fix Version].[Version].Members,
DateInPeriod(
[Fix Version].CurrentMember.get(‘Release date’),
[Time].CurrentHierarchyMember
)
AND
([Time].CurrentHierarchy.DefaultMember,[Measures].[Issues created]) > 0
),
[Fix Version].CurrentHierarchyMember.GetString(‘Release date’),
', ’
)
END