Hi,
We have multiple Jira projects for different squads and everyone have unique sprint names. For example for one squad the sprint name is AWSCypher S299. The last 4 string determines the sprint number. Im trying to extract S299 using the below measure, however it is giving me the output as “Squad” . I would like to know what is going wrong here.
CASE
WHEN IsEmpty([Sprint].CurrentMember.Name) THEN
NULL
ELSE
– Extract last 4 digits of Sprint value
Right([Sprint].CurrentMember.Name, 4)
END