Measure to show Transition Author and Transition Date

Questions & Answers
,
4

Hi @knayak,

You can define calculated measures that get the name of a user who made the last transition as well as the date of that transition.

To get the latest transition date, you might use a tuple of measure “Transition from status last date” and particular Transition from Backlog to In Progress.

([Measures].[Transition from status last date],
[Transition].[Backlog => In Progress],
[Time].CurrentHierarchy.DefaultMember)

To get the user name, you might want to look at transition authors who moved issues between states and pic the latest author. The principle for calculation is to filter transition authors that had made a particular transition and validate if it is the latest transition between those statuses. If so, then get a user name.
The formula to get a user who moved an issue from Backlog to In Progress might look like this:

Generate(
  --fiter set of transition autors
  Filter([Transition Author].[User].Members,
    --user is the author of the last transition
    Iif( 
      --if date when user made transition
      DateToTimestamp(([Measures].[Transition from status last date],
        [Transition].[Selected for Development => In Progress],
        [Time].CurrentHierarchy.DefaultMember)) = 
      --matches the date of the latest transition
      DateToTimestamp(([Measures].[Transition from status last date],
        [Transition].[Selected for Development => In Progress],
        [Time].CurrentHierarchy.DefaultMember,
        [Transition Author].DefaultMember))
      --then get the transition author
      ,1,0) > 0)
    ,
  --and return user name
  [Transition Author].CurrentMember.Name, ","
)

You may also check out the community post with another example of how to list users who have made particular changes to issue:

Best,
Zane / support@eazyBI.com

2 Likes