# Measure to show Transition Author and Transition Date

**URL:** <https://community.eazybi.com/t/measure-to-show-transition-author-and-transition-date/4536>\
**Category:** Questions & Answers\
**Tags:** history, mdx\
**Created:** [May 29, 2020, 1:32pm UTC](https://community.eazybi.com/t/measure-to-show-transition-author-and-transition-date/4536 "2020-05-29T13:32:00Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [June 5, 2020, 3:14pm UTC](https://community.eazybi.com/t/measure-to-show-transition-author-and-transition-date/4536/4 "2020-06-05T15:14:04Z")

</div>

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:

> [@How to list all assignees of an issue](https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue/3297/2):
>
> Hi @liu.jingjing, Yes, you can see all previous assignees of an issue. The assignee change history is imported in eazyBI, and you can see previous assignees using measures “Issue history” or “Transitions to assignee” together with Assignee dimension. For more details on the available historical measure, please see the documentation: [https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history](https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history) For listing assignee names in one field, you might want to create a n…

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

_[View the full topic](https://community.eazybi.com/t/measure-to-show-transition-author-and-transition-date/4536)._